How to open a filtered form checking password first?

[Ryno Bower]

I have two forms. OperatorDetails Edit and EditOperator. What i want to do is the following.when i open form EditOperator there is two unbound text boxes, txtOperatorEdit and txtPasswordEdit . So when i type the operator in and tge password, i want it to check if the password matches the password for the specific operator in a table called Operators. If the password matches up then it must open the form OperatorDetails Edit on the specific operator just entered in the first form. The reason i want to do this is that operators can edit their own details and will not be able to edit or look at other operator's details. This is just some sort of security i want to implement. If anyone ciuld please help me with a code and also suggest anything similar to this kind of procedure. Thanks very much. Ryno

[NeoPa]

Ryno, You are not allowed to ask for work to be done for you.

We answer specific questions, and we generally expect you to show us that you have at least made an attempt at providing a solution yourself before we go to any effort on your behalf.

There are a number of ways to handle security without logging in specifically to an Access database (EG If logged onto a network you can utilise the account name already used - There are a number of threads already devoted to this and similar topics on Bytes).

Very generally, to handle this yourself, you would allow the operator to enter their security details then encrypt the password and use DLookup() to check the encrypted entered password with the encrypted stored password in the table for the ID entered.