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


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.
 
Ad

Advertisements

Joined
Jul 11, 2010
Messages
5,758
Reaction score
552
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:
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top