refering to a field on a form

[StuartR]

I am sure this will be easy but ....

I have a form, with a button that triggers a Private Sub Form_AfterUpdate()

I want to put in a bit of code that determines if an email field is blank, and therefore performs one action or another. The code (and versions of it that I have tried) is as follows, but I am getting errors such as Object Required, object not defined etc.

Private Sub Form_AfterUpdate()

If [email 1] Is Null Then
MsgBox ("No email address has been entered")
   'do something here
else
   'do something else
end if

What is wrong with my "If" line ???



Cheers

Stuart

[ranman256]

is [email 1] the name of the text box? (its best not to put spaces in names) you can always ad ME. to the front of the control too. if me.[email 1] ...

and the test for null on a form is:
If isNull([email 1]) Then

in a query it is: [FIELD] is null

[StuartR]

Thanks Ranman