2 ways
Before your report opens you can have a form open (say frmDatesForReport) with two unbound text boxes that would store these two dates say txtDate1 and txtDate2. After this information is filled in you would minimize this form and open the report and use
SELECT * FROM Pay WHERE PayDate...
If you define a custom toolbar. Go to Tools..Toolbars..Customize give your toolbar a name and then add features to it, Then go to the properties of a form and set the menu bar and the toolbar for that form to one you just defined it WILL follow the database around. I have done it many times...
I generally define my own custom toolbars and menubars. You can make them so they only have 1 option - Exit. Then in the properties of forms and reports set your custom toolbars to open with the forms and reports. MVas
I can't help you with the macro, but I can help you if you want to use code. I have the double click event for the text box holding the ID number of the record to read:
DoCmd.OpenForm "frmFormYouWantToOpen" 'opens form Issue for single record view
Forms![frmFormYouWantToOpen].Filter...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.