Well, that looks like a nice way to do it. But some of it is over my head, and I'd have to do some major re-work to implement it. I'll save your example for use later though, thank you. In the meantime, I came up with a quick-fix. On the criteria form, on button click, I added a line to make the form invisible:
Code:
Private Sub Command22_Click()
On Error GoTo Command22_Click_Err
DoCmd.OpenReport "Report1", acViewPreview, "", "", acNormal
Forms![Criteria1].Visible = False
Command22_Click_Exit:
Exit Sub
Command22_Click_Err:
MsgBox Error$
Resume Command22_Click_Exit
End Sub
Then, in the Report's report close event, I put
Code:
DoCmd.Close acForm, "Criteria1", acSaveYes
Do you see any potential problems with that solution?
The minimize window idea didn't work; it just minimized to the bottom left where the print preview page selector is and it's just as much in the way there.
Now if I could just figure out why the subform is getting pushed to the next page.