Open the your form and enter the parameters for the report. Then open the report in design view and look at the RecordSource in Datasheet view and see if you have any records.
Re-Running a report
Administrator
Windows 7 
Access 2010 (version 14.0)
Open the your form and enter the parameters for the report. Then open the report in design view and look at the RecordSource in Datasheet view and see if you have any records.
Advanced Beginner
Windows XP Access 2002
Thank you RG... I will try this and get back to you. I appreciate your help.
Randy
Administrator
Windows 7 Access 2010 (version 14.0)
Remember, you need to keep the form open so the query can pick up the parameters. Have fun.
Advanced Beginner
Windows XP Access 2002
I made the mistake of copying an existing form that I use for entering parameters for a different report and changed things to work on the new report. For some reason the report didn't like the two date text boxes (BeginDate and EndDate) used for entering the dates.
Once I deleted those two text boxes and put two new text boxes on the form with the same names, everything worked fine. It doesn't make any sense to me but that is what the problem was.
Thank you for your help. Your suggestion got me headed in the right direction.
Thanks,
Randy
Administrator
Windows 7 Access 2010 (version 14.0)
That's great Randy! That's what we do here. Are you ready to follow the link in my sig and mark this thread as Solved?
Posting Permissions
Reply With Quote