The message means you're passing the wrong type of data to something & often that value is null to a field that cannot except it.
What I see as being potential problem is that you seem to be looking for form values on close (AT). At that point, Unload has already happened thus there shouldn't be any values to retrieve. Unload event might not be too late but if you're using a button to close the form, I would use that event. Sometimes the error is the result of forgetting that the combo value and the chosen value are not the same data type when 2 or more columns are involved.
Last edited by Micron; 08-11-2019 at 07:11 AM.
Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.