Run-time error 94; Invalid use of a Null

[CLevent21]

When some uses the navigation button and they get to enter the data into the form, if they hit the navigation button again, I get the Run-time error 94; Invalid Use of a null and it asks to end or debug. Is there a way that I can prevent this from crashing?

[compuGEEK]

It would help if you posted some code :)

[Tonatiuh]

If the problem is in a variable or database field, may be you can use the 'IsNull' function to prevent the problem.


If IsNull(variable) then
'The variable has a null value
Else
'The variable has a value
End if


I hope this can help you. If not, please be more explicit or post some code.

Good Look!