close form

[rjoshi2]

What I would like to due in my program is when a person open form or table it close all the other form or table that are open. Then when a person close the current form or table that he is working in then my program open up the switchboard (i.e. this will only let one form or table be open at once). My question is how can due this any suggestion would be helpful.

Thank You,
rjoshi

 

[SgtJarrow]

Accordign to your requirements, you will onyl be able to have one form (or table) open at a time. With forms and reports, it is pretty simple. I don't even no if it can e done with opening the table, but just create a form based off the table and you have fixed that too....

In the unload property for each form, put

DoCmd.Close
DoCmd.OpenForm "Switchboard"

In the onlick event for each button on the switchboard, put

DoCmd.Close

before the DoCmd.Open line

You will probably need to remove the tables buttong if you are using a default switchboard created by the Switchboard wizard. Like I said above, just make a form (if one doesn't exist) for each table and put a button identical to the other form buttons in your database. If we knew what it was we were doing, it would not be called research, would it? - Albert Einstein

Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com