Object required message (Text validation)

[Phonik]

Hi all

I keep running into a problem when I perform some basic validation on my form. Basically, when the user clicks an exit button, some code is run to make sure that they have completed all mandatory text boxes. The code I am trying to use is:

If me.company_Name = "" then

msgbox "blah blah..."

I have also tried If me.company_Name is Null/ = Null but again neither of these work and bring back a message "Object required" or "Invalid use of Null"

Please can anyone help?

Thank you.

 

[namliam]

Is null is the SQL variant... in VBA you must use ISNULL(ME.Company_name)