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

DoCmd.OpenForm and DpCmd.OpenQuery issues

P: 46
Hi community experts,

May I know is it possible to display an error message or not opening a form or query when users provide with the wrong inputs in the DoCmd.OpenForm and DoCmd.OpenQuery properties. If that is possible what must be done to achieve?
Feb 11 '07 #1
Share this Question
Share on Google+
2 Replies


NeoPa
Expert Mod 15k+
P: 31,492
How can a user do anything with DoCmd.OpenForm? That's code.
What is it that you have the user doing exactly? Is it entering information on a form?
Feb 11 '07 #2

ADezii
Expert 5K+
P: 8,638
Hi community experts,

May I know is it possible to display an error message or not opening a form or query when users provide with the wrong inputs in the DoCmd.OpenForm and DoCmd.OpenQuery properties. If that is possible what must be done to achieve?
Prior to executing any Command involving User Inputs, those same Inputs should be thoroughly evaluated, and the User should be notified when they are not in a specified range, proper data type, empty, etc.
Feb 12 '07 #3

Post your reply

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