Getting parameters sent to a report via parametrised query

[mrcraigwest@hotmail.com]

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.

[pbaldy]

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.

[mrcraigwest@hotmail.com]

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.

This did the trick!

[pbaldy]

Happy to help and welcome to the site by the way!