I have a form where the user selects a project from a combo box, once selected the detail is displayed within the form. I have a button which allows for the user to print preview the selected report howver when selected the report open behind the form so I used this command:
DoCmd.OpenReport "rptEmployees", acViewPreview
The problem is that the form closes but the reference to the combo box of which project to display did not have time to query and run, so I get the message box to type in the project number. How do I have the report run, display for the referenced project and the form to close all in one command?