Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report hides behind Switchboard

Status
Not open for further replies.
bitech

bitech

Programmer
May 19, 2001
63
0
0
US
I have a function in the toolbar that produces a report. When the report is open in preview, it is hidden behind the switchboard. Is there a way without closing the switchboard that I can have the form receive the focus.
 
Sort by date Sort by votes
Couple of ways i can think of. Probably the easiest is to put code on the on-open event of the report to bring it to the front e.g. DoCmd.RunCommand acCmdBringToFront

Or you could make your switchboard invisible when the report opens and then visible again when it closes.

HTH

Nigel
 
Upvote 0 Downvote
thanks for the advice...actually when I posted that, I thought about the DoCmd.SelectObject function and I have decided to use that
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Dophia
  • Locked
  • Question
Problem using code to open a form, but works to open a report
Replies
1
Views
60
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Create report for each record in a datasheet subform 1
Replies
2
Views
57
TrekBiker
TrekBiker
TrekBiker
  • Locked
  • Question
Create multiple reports 1
2 3
Replies
47
Views
215
TrekBiker
TrekBiker
telephoto
  • Locked
  • Question
How to force a switchboard to refresh when closing another form? 1
Replies
2
Views
62
telephoto
telephoto
TrekBiker
  • Locked
  • Question
Customising the Switchboard
Replies
1
Views
22
TrekBiker
TrekBiker

Part and Inventory Search

Sponsor

Back
Top