Advanced Report Filter

[bigdan5428]

I'm trying to create a form for applying a filter to a report that includes a "Beginning Date" txtbox, a "End Date" txtbox, and a combobox. I am trying to filter the report so that the filtered results will only fall between the beginning date and end date and that one of the fields in the report is limited only to the combox selection. I have only been able to do one or the other when applying VBA code to the command button, but i can't figure out how to do both. I appreciate any help!

[ConneXionLost]

Build a query that uses the form fields as criteria for filtering the query as you described.

Make the report use the query as the Record Source.

Note - the form must be open for the report to work.

Cheers,