message box with wrong parameter

  • Thread starter Thread starter anonymous
  • Start date Start date
A

anonymous

Could anyone tell me how can make a message after when
input wrong parameter with Query?
 
I think you are opening a query that has a parameter value. This means you
cannot capture or check the value

You will need to use a form to capture the parameter. Then, you have the
chance to check the value before opening the query.
 
Not clear what your situation is. If there's a chance you can enter a
"wrong parameter" for a query, consider a different approach.

You could create a form (unbound), create a combo box (which lists only
correct values), and create a command button which runs the query. You'd
have to modify the query to use the value selected in the combobox as its
parameter, rather than an entered value.
 
Back
Top