Hello,
After I open a Form or Report which is on "pop up", how can I set it to come on top of other open Forms/Reports?
Thank you
Hello,
After I open a Form or Report which is on "pop up", how can I set it to come on top of other open Forms/Reports?
Thank you
Also set the modal property to true
modal means you can’t change focus to other forms until it is closed. If you don’t want that, in the form open event, use code to change it to false
You can do something like this:
DoCmd.OpenReport "StatementOfAccount", acViewReport, , sCrit
DoCmd.SelectObject acReport, "StatementOfAccount" 'bring to front
Is "StatementOfAccount" the name of the Form or Report?
Should I put the code in the VBA part of the Form/Report?
Thank you
what do the parameters say?
StatementOfAccount is the report. You can easily see that by scanning the code.
The code would go wherever your current code is opening the report, probably behind a form.
The code given is a general case, meant as a guide. It will need to be adapted to fit your specific requirement.