One button on my main switchboard takes me to a second switchboard that has (for purposes of illustration) two buttons: the first opens a table in edit mode and the second takes me back to the main switchboard. This second button works fine if I haven't clicked the first one. The one that opens the table uses a one-line macro that opens the table - very straightforward. When I close the table and go back to the secondary switchboard, the second button no longer works. In order to get back to the main switchboard, I have to close the secondary one and reopen the main one - fine for me, but not so fine for my users. I have done exactly this same sort of simple programming in other databases and it has worked like it's supposed to. This is in Access 2007. Any ideas?
Here's the one-line macro: Macro Name Action Arguments OpenLATransTable OpenTable tblLiveAuctionTransactions, Datasheet, Edit The other button just goes to the main switchboard. Barbara Mann
