DoCmd.OpenForm and DpCmd.OpenQuery issues

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • technocraze
    New Member
    • Jan 2007
    • 46

    #1

    DoCmd.OpenForm and DpCmd.OpenQuery issues

    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?
    Last edited by technocraze; Feb 11 '07, 05:20 PM. Reason: typer error
  • NeoPa
    Recognized Expert Moderator MVP
    • Oct 2006
    • 32669

    #2
    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?

    Comment

    • ADezii
      Recognized Expert Expert
      • Apr 2006
      • 8834

      #3
      Originally posted by technocraze
      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.

      Comment

      Working...