validate field in query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
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]
 
Back
Top