Form Error

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)
 
G

Guest

Nevermind. I shouldn't have used a null value with a text field. Just <> ""
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top