I have a report based on a parametrised query asking for start and end dates.
How can I use VBA to capture these to put them in Report title e.g. Sales for period 1/6/2014 - where italics are user data entered?Thanks.
I have a report based on a parametrised query asking for start and end dates.
How can I use VBA to capture these to put them in Report title e.g. Sales for period 1/6/2014 - where italics are user data entered?Thanks.
If you use the bracketed criteria method, no code required. You can have a textbox:
="Sales for period " & [Enter start date]
the bracketed text must exactly match the criteria. The same method would work for criteria from a form.
Happy to help and welcome to the site by the way!