Access Switchboars

Copper 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

@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.