Full Version: Forcing a form to the background
UtterAccess Forums > Microsoft® Access > Access Forms
sonarman
I have an Address book Form with several options. One opens a "switchboard" form and lets me
select one of several "Reports". When the report is displayed, the procedure closes the switchboard
and clears out any filters used in the originating form. I need the "Report" to remain the top window
until dismissed, with the originating form to showing in the background. It ends up in front instead.
Any ideas??
Sonarman
theDBguy
Hi,
Welcome to Utter Access!
It probably depends in the order of command execution in your code. If you are opening the report before clearing up the original form, you might try adding a SetFocus action at the end. For example:
Reports!ReportName.SetFocus
(untested)
Hope that helps...
sonarman
Thanks for the response. Looking at the VBA help pages, it looks like it should
work, but didn't.
solved it by moving the filter clearing code out of the switchboard proceedure
and made it a "onClose event" in the report, so it comes up the way I want.
Thanks
theDBguy
You're welcome. Glad to hear you were able to fix it. Good luck with your project.
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.