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.

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?

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"KPalmer" <(E-Mail Removed)> wrote in message
news:E02CAFB4-D970-404E-B2E9-(E-Mail Removed)...
>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.

Why are you using a combobox for password entry?

"KPalmer" <(E-Mail Removed)> wrote in message
news:E02CAFB4-D970-404E-B2E9-(E-Mail Removed)...
>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.