validate field in query

S

smboyd

I have a query that is based on a table containing job numbers. When the
query runs it prompts the user for the job number. How can I validate that
it is a valid job number from the query?
 
R

Rick B

If the query returns nothing, then it is not valid.

If you want to only allow valid entries, then you would need to make the
entry on a forma and apply some edits. Personally, I would make it a
drop-down box on an unbound form if I wanted to force valid entries. I
don't think the prompt built in a query can do any of this editting.
 
J

John Vinson

I have a query that is based on a table containing job numbers. When the
query runs it prompts the user for the job number. How can I validate that
it is a valid job number from the query?
Click to expand...

Use a Form based on the query, and use a Combo Box (with its Limit to
List property set to be true) to enter the job number.


John W. Vinson[MVP]
 
Top