Need help generating a report with an input field 1

[rfalbright]

I want to generate a report using a date that the user can enter. How can I do that? Can I create a form for the user to enter the date and link it to a report? Thanks for the help.

Frank

 

[ninfan]

Here's what I do:

- Create a form with an input text box or combo box
- Refer to that text box or combo box in the query that supplies data to the form
- Put a button on the form to either print preview the report or send it directly to the printer

 

[rfalbright]

I still don't quite understand. I have created my form with a text box to enter a date. I have created a query to print the fields I want and set the date to the date field in my form like:

[Forms]![MyFormName]![MyFormFieldName]

Now, how do I link the query to the report?

 

[ninfan]

The "RecordSource" of the report is the query that drives the report. Do you already have a report built?

 

[rfalbright]

I got it. I put a button on the form that linked it to the report. Thanks for your help.