I have a form that asks for a license plate number to act on. Once the plate number is entered and Next is clicked, a lookup function fires that looks for a matching license plate in a different list. If the plate number is found, the name of the vehicle owner, make, model and color are returned and update fields on the current form. This all works fine. My issue is I do not have a way to determine if a match was not found, only if one was. I am trying to display a message if the search does not find a match, but am running into a block. I cannot find any functions that would indicate that no result was found.
This would be similar to a SQL query script that would look for EOF (end of file).
If EOF then
do something
else
do something else
end if
Does anyone know if this is even possible?
