Invalid use of Null (1 Viewer)

Jun 3, 2022

I have an access file (.accdb) that performs all codes properly, has no errors, etc., but when I create it to a user file (.accde) and try to search/filter a name within a form.

I receive this error:
"The expression On change you entered as the event property setting produced the following error: Invalid use of Null."
*The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure]
*There may have been an error evaluating the function, event, or macro*

How can I remove this error from the user file, .accde.? Not understanding where my issue comes in.

Put a message box and an error handler in that routine.
Make sure you can identify where the error has occurred in the message box text - then create the accde.

Now see where the message box pops up, at least that will give you a starting point as to where the error is.

Users who are viewing this thread

Top Bottom