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

bootneck02

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:
 

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

Similar Threads

how to pass a parameter to a query base of a query that is the base of a report 0
Update a query based on user input in a form. 1
Opening a form from a list box based on SQL query 1
How to get a query to call the parameter form 4
two form based on the same parameter query 6
passing a parameter based on multiple selections 7
Query Parameter Failure 5
Parameter query based subform showing all records onload 1

Top