Creating a report from a data entry form

[meldrape]

Greetings,

I have a database and I need to create a report from a form (data entry).... In other words, the user opens the form, he has three drop down boxes to choose stuff from, and a beginning date box and ending date box, an invoice date box, then he clicks a submit button and VOILA a report is created. Since I am NOT an Access guru, I don't even know where to start.

I have created the form with the dropdowns and the text boxes. I have created the report with the fields I need,
but... How do I get the info he types into the boxes into a query that will run a report and more confusing yet, if he doesn't choose any information, how do I get it to display ALL values in the report?

Any help would be greatly appreciated. Thanks.

 

[Chris RR]

To get data into a query, you need to save it in a table. You might want to find a good Access reference book (try the Que books, there are others).

If you just want to reference a form field in a report, do something like this in the control source of a text box:
=[Forms]![fMyForm]![Some_field_name]