Select criteria for report through a form

[brokenwh]

Good Day:

I am trying to create a form where you can select different criteria from combo boxes (i.e, account names, months, year) and use those criteria to print reports.
I am not sure where to start and how to organize this. Any help and suggestions would be GREATLY appreciated.

THANKS

 

[dcx693]

Use a query as the recordsource for the report. In that query, reference the fields on the form where the user chooses criteria using the format: Forms!yourform!yourfield.

 

[brokenwh]

THANKS - One more question

I appeciate the help and so far it is working GREAT. I do have one more question. All of these entries are based on a date (mm/dd/yyyy).

On my form I need a way to be able to select the month and year and have it relate back to the mm/dd/yyyy format. Any suggestions here?

Thanks again!

 

[dcx693]

There are functions to create dates based on having the month and year. Try the Dateserial function.