Can I validate data in a combo box vs another table?

[KPalmer]

I have a form used as a password screen with a combo box for password data
entry. I have a table which houses the passwords. I need the combo box on
the passwoprd form to screen the data entered to validate if an acceptable
password was entered that matches the listing in the table. If it matches, I
want to open a specific table with edit capabilities. If it doesn't match, I
want an error to appear.

 

[Douglas J. Steele]

That sounds like a very odd requirement.

If the passwords are presented in a combo box, what prevents the user from
simply selecting each possible password from the combo box in turn until one
works?

 

[microsoft]

Why are you using a combobox for password entry?