Form Error

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

Guest

I'm having trouble using a field with a null value in a calculation.

pcount = 1

If Me.ADD_NAME1.Value Is Not Null Then pcount = pcount + 1

the problem is if it is null I gfet a message that says

Object required (Error 424)

What do they mean? The form and text field exist. The delimter adds value as a
popup choice so I know it recognizes the object.

Anyone know whats happening?
(e-mail address removed)
 
Nevermind. I shouldn't have used a null value with a text field. Just <> ""
(e-mail address removed)
 
Back
Top