I've got a small form that has one combo box on it. The user is to choose an item and hit "Go". A report should then popup based on the item chosen in the combo.
I've done this for opening a query, but I can't seem to figure out the how to open the report based on the data.
Here is my Logic...
1) Create a Query with a Criteria feild containg [Form]![MyForm]![cboItem]
2)Create a report and set the Record Source to the query I just made
3) In the code of the "Go" Button I added "DoCmd.OpenReport ("MyReport")"
The result is that no report is displayed, instead it prints off the report to my PCs default printer without even showing me the report or prompting for me to choose a printer.
So it technically works, I think I'm just missing something.