I have a report, that I want to display on top of the form that called it.
This is how my db works at the moment:
1. Main Menu form is displayed to user
2. User clicks button on Main Menu - this opens a DIALOG form ('search' form)
3. On the DIALOG form, user clicks to generate a report
4. Report is generated, but is displayed BEHIND dialog form - therefore cannot see the report properly.
I need the 'search' form to be 'modal' because I don't want the user re-activating the MAIN MENU, while it is still open
Is there any way of making my report print preview sit ON TOP of my 'search' form? i.e. is there a way of making my report pane modal as well?
Originally posted by Marvels
Dim rptCurrentReport As Report
DoCmd.OpenReport "Qry_Naam", acPreview
Set rptCurrentReport = Screen.ActiveReport
thanks for the suggestion, but unfortunately that code only works if I set my 'search' form as a 'normal' form. Problem is, that if I set the 'search' form to being 'normal', users can activate the main menu without closing down the 'search' form.