Hi there, I have several reports that require a date range so I created a form with all the available reports and once a user click on a report, then another form appears that allows the user to enter the date range. This data range form has a 'Print' and 'Print Preview' build button. how can I make this buttons to recognize which report the user is selecting the date criteria for? (when I started this database it was only for one report, therefore the 'Print and PrintPreview' buttons were coded for that specific report) but this is not the case any more.

Thank you for your help
 

---

Answer from Richard Rost:

Here's what I would do…

Make a combo box that contains all of the names of your reports. You can have two columns - one for the system name of the report "AccountsPayableR" and the english name "Accounts Payable" that's visible - if you want.

Now, make two TEXT boxes on your form. One for start date, the other for end date.

Now, make a command button that launches the report based on the combo box:

Docmd.OpenReport ComboBoxValue…

For the reports that are date sensitive, have them pull the dates from your form:

=Forms!FormName!StartDate

See this tutorial for more help:

If you want to refer to a value on a Form, you can use the notation:

Forms!FormName!FieldName

You can use this notation inside of queries, other forms, or even reports. I have a free tutorial that explains how to use this:

http://599cd.com/tips/access/forms-formname-field-notation?key=BlFAlEx

Note that if you're refering to a value on a SUBFORM, the correct notation is:

Forms!FormName!SubForm.Form!FieldName

Crazy, I know. Enjoy! Hope this helps.