Solved Customize the error message "You tried to assign the value Null to a variable that is not a Variant data type"

[zelarra821]

Hi.

I have a form with a dropdown. As it takes values from another table with which it is related, and saves the code in the source table of the form, if the user leaves the field empty, the message "You tried to assign the value Null to a variable that is not a Variant data type ". I have tried with all the possible events, but none of them allow me to customize that error (which would basically consist of replacing the error by putting a default value that I always add in the drop-down, type No data).

I don't know if you understand what I mean. How could I do it?

 

[pbaldy]

I would test for it in the before update event:

Before update

You can probably also catch it in the form's error event if you want.

 

[zelarra821]

Thank you very much for answering. It does not work. Look:

 

[pbaldy]

The link recommends the form's before update event, not the individual control's.

 

[zelarra821]

It keeps giving me the same error

 

[pbaldy]

Can you attach the db here?

 

[zelarra821]

Here it is

 

[pbaldy]

Okay, try the second suggestion of using the form's error event:

Error Event [Access 2003 VBA Language Reference]

docs.microsoft.com

Code like:

  If DataErr = 3162 Then
    MsgBox "Your message here"
    Response = acDataErrContinue
  End If

 

[zelarra821]

Ok, now it works perfectly. Thank you very much for the help.

 

[pbaldy]

Happy to help.