Use two combo boxes in a form to produce a single record report.

[GeneErz]

I want to use a form with two combo boxes. The first pulls from a list of names and the second a date. When the name and date is selected, I want it to produce a single record report based on the data in the combo boxes. This will all be pulling from a single table.

[ranman256]

The report is based on a query: qsRpt1
the query qsRpt1, will have the two combos as criteria.

select * from table where [client] = forms!frmRpts!cboName and [date] = forms!frmRpts!cboDate


Be sure to use the BUILDER (magic wand icon) to build the form path. All you do is pick the item you want, it will spell it correctly.
Have a table called tReports , and you can have users pick a report from a listbox.

[GeneErz]

Thanks for the quick response ranman256. I'm new to Access and I don't completely follow what you're suggesting. Can you give me a step by step?