Access How to Validate the query parameter before loading the form that is based on the query iteself?

I

ISA

Joined
Nov 3, 2016
Messages
2
Reaction score
0
Hi all,,
This my first entry in this forum.
I have a form based on a query.
I am taking the parameter (say INVOICE-NO) from a message box and loading the form.
In the Select Query, I made the WHERE = to the Message Box value, INVOICE-NO.
It works as long as the Invoice exists. However, if it does not exist, then get errors "Type Mismatch" followed by "You Can't Assign a Value to this object" followed by Error 2950 and the gets out of the form.

Please Help as soon as you can.
 
Hi ISA welcome to PCR I am not able to answer you question but I am sure one of our team will be able to help. Once again welcome and do join in and enjoy.:thumb:
 
Back
Top