Home

Access Switchboars

%3CLINGO-SUB%20id%3D%22lingo-sub-1176469%22%20slang%3D%22en-US%22%3EAccess%20Switchboars%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1176469%22%20slang%3D%22en-US%22%3E%3CP%3EI%20created%20a%20switchboard%26nbsp%3B%20to%20allow%20a%20user%20to%20navigate%20a%20database%2C%20The%20main%20switchboard%20that%20has%20buttons%20that%20when%20pressed%20send%20the%20user%20to%20different%20forms%20within%20the%20database.%26nbsp%3B%20On%20each%20of%20the%20forms%20that%20open%20I%20have%20a%20command%20button%20that%20opens%20the%20Main%20Switchboard%2C%20however%20the%20form%20does%20not%20close%20but%20remains%20open%20underneath%20the%20Main%20Switchboard%2C%26nbsp%3B%20Can%20anyone%20tell%20me%20how%20to%20have%20the%20form%20close%20on%20LostFocus.%26nbsp%3B%20Thank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1176469%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1177538%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20Switchboars%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1177538%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F558990%22%20target%3D%22_blank%22%3E%40WilsonRebound%3C%2FA%3E%26nbsp%3BThe%20most%20direct%20way%20to%20do%20this%20would%20be%20to%20add%20a%20line%20to%20the%20command%20that%20opens%20the%20other%20forms%20from%20the%20switchboard.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3BDoCmd.Close%20objecttype%3A%3DacForm%2C%20objectname%3A%3D%22frmSwitchboard%22%2C%20Save%3A%3DacSaveNo%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlace%20this%20line%20after%20the%20line%20that%20opens%20other%20forms.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I created a switchboard  to allow a user to navigate a database, The main switchboard that has buttons that when pressed send the user to different forms within the database.  On each of the forms that open I have a command button that opens the Main Switchboard, however the form does not close but remains open underneath the Main Switchboard,  Can anyone tell me how to have the form close on LostFocus.  Thank you.

1 Reply
Highlighted

@WilsonRebound The most direct way to do this would be to add a line to the command that opens the other forms from the switchboard.

 

 DoCmd.Close objecttype:=acForm, objectname:="frmSwitchboard", Save:=acSaveNo

 

Place this line after the line that opens other forms.

Related Conversations
Tailored Access database- where to order
masha2020 in Access on
1 Replies
Creating a live connection with Microsoft Planner
kasandra in Planner on
2 Replies
Sequencing based on the Value
rolo1007 in Access on
3 Replies
How to start a access web database
Leber01 in Access on
1 Replies
DoCmd.ShowAllRecords
RichardHG in Access on
1 Replies