By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,226 Members | 1,435 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,226 IT Pros & Developers. It's quick & easy.

Cancel parameter input and load switchboard

P: 2
Hello All,

I'm quite a novice but I'm trying to get a database together at work. I have an effective database but I'm trying to tie up all the loose ends to make it fool proof!

I have a select query attachted to a form. The query asks the user to enter some data in order to retrieve the results. The form is then attachted to my switchboard. A button on my switchboard closes the switchboard and opens the form via a macro.

The thing is if you press "cancel" to the option to enter criteria it closes the form. How do I get it to re open the switch the board when the user selects "Cancel". I suspect I need to go back to the query and put something in here but I'm not sure what.

Any Advice much appreciated!

Thanks

Laura
Jan 6 '12 #1
Share this Question
Share on Google+
2 Replies


ADezii
Expert 5K+
P: 8,679
Laura, are you referring to a Form whose Record Source is a Parameterized Query? If this is the case, you basically cannot take any action based on the User cancelling the Parameter Prompt. You would then need an alternative Method of requesting the Parameter from the User, so you can control his/her Response.
Jan 7 '12 #2

NeoPa
Expert Mod 15k+
P: 31,707
Never close the Switchboard form. Simply hide it, but only when the other form has opened successfully.
Jan 9 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.