Error Trapping a Null or Blank query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that prompts the user for a "User Id". I need to trapping the
error if the user inputs a invalid ID or blank ID.

The query opens a form if the user ID valid.
 
iholder said:
I have a query that prompts the user for a "User Id". I need to trapping the
error if the user inputs a invalid ID or blank ID.

The query opens a form if the user ID valid.
Click to expand...


Air Code follows:

If IsNull(Forms!YourForm!YourControl.Value) OR <other expression> Then

<code if error>

Else

<code if no error>

End If


Sincerely,

Chris O.
 
Back
Top