mikeymoon2
New member
- Local time
- Today, 02:52
- Joined
- Dec 18, 2008
- Messages
- 1
I am building a switchboard to run a simple Access database. The main page has two options: GENERAL and ADMIN. Clicking on GENERAL opens another page with a series of buttons to open various forms etc. and is not a problem. But when I click on ADMIN I want to go first to a blank form (not a switchboard page) with a password box. Entering the correct password should then go back to another switchboard page (OPTIONS) with various admin options. The problem is that the macro on the blank form takes me back to the main page of the switchboard (default) and not to the OPTIONS page. I have tried changing the code in the macro to the switchboard ID/ Item/ Argument for the OPTIONS page as shown in the table of switchboard items, but I get a warning that the macro can only run 20 times and that I need to set a condition limiting that number of times. Am I missing something simple about directing the macro to open OPTIONS (and not the default first page) and/or how do I set a condition to run the macro only once (assuming it is going to work)? Thanks for your help!