Validation rule that searches for value

  • Thread starter Thread starter amber
  • Start date Start date
A

amber

I want to create a validation rule for a control on a form
that checks the value entered for a match in another
database table. I want to be sure that users are entering
a value that is a primary key (an employee id) in a
separate table.
 
Best approach would be to use a ComboBox that has the other table as it's
control source.
 
I thought about that, however, I have over 3000 employee
ids that would be used.

Would a combo box still be feasible?

Thanks,
Amber
 
It might be a bit slow unless you could find some ways to limit the number
of employee ids a given user might have to look through (perhaps by
department).
 
You must log in or register to reply here.

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

validation rule for not allowing duplicate entries 3
validation rule (for a record in a table) with dlookup 7
Validation Rule 2
Validate a Date 1
Set validation rule for many fields with vba? 7
Validation Rules for a Control on a Form (?) 4
validation rule 1
Validation Rule for maximum length 6

Back
Top