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:
ECHO False
DoCmd.Close
DoCmd.Maximize
DoCmd.OpenReport "rptEmployees", acViewPreview
ECHO True

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?

Thank you,
Deborah

In the form try using this:



In the form's On Open event, I you could use something like:



Edited by: HiTechCoach on Sat Sep 20 1:08:06 EDT 2008.

I have a command button which allows the user to print preview the report for the slected project, do I code on the onclick of the button?

Yes. I assumed that this was the code for the click event.

TIP: when posting VBA code, include all the code for the event

Example

Deborah

Not sure if I fully understand the problem, however I will make some comments that may help.

- If the report opens behind the form, then probably this is because the PopUp and/or Modal properties of the form are set to Yes.

- When I want to close a form but hold on to the value of a control for a little longer, then I assign the value of control to a variable before the docmd.close statement. The variable exists until the sub finishes. So it goes about like this:

variable = me!control

docmd.close

use variable to do whatever is to be done

end sub

Again, thank you! It works great.

Deborah

Thanks Polant, This information helps me too.

You're welcome!

Glad we could assist again.