Date Macro

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

I have several reports based on queries that use [Enter
Term Date] as a criteria. I have created command buttons
for each of the reports that print them after you enter
the date. I was wondering if there was a way to use a
single command button to print all the reports and to only
have to enter the date once and have it applied to all the
reports.

Thanks
 
Eric,

Best way to do this is put an unbound textbox on the form, where you
enter the term date required, and then in your queries, instead of the
parameter prompt in the criteria, you refer to the textbox on the form,
using syntax such as [Forms]![NameOfForm]![NameOfTextbox]
 
Back
Top