My report record source is genreated by the users selection of which items they want on teh report. I put a button to "preview report" before they print.Any ideas on how to change the record source before the print preview screen comes up?
How do you use the VBA to reference the recordsource of the report when you are on a different form?
i currently have this as the VBA,
Reports![reportquery].RecordSource = reportSQL
it runs when i use it as a query, but i get an error saying that "the referenced report is mispelled/does not exist" which is weird cuz when i comment out the line, the report runs fine
When i put my sql code into the "on open" event in the report, it says that "You cannot change the record source during a print preview"
Let me know,
Edited by: sunfire4jc on Thu Aug 11 23:55:00 GMT-5 2005.