Error Trapping a Null or Blank query

[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.

 

[Chris2]

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.

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.