Linking a textbox and a query to validate it?.

[Bakta]

Hello,

I have a form where a user select a service (S_name) and type a required password in a textbox before carrying on.

I must match the data in the textbox to a field (S_sec) which match (S_name) above. After which I send back a valid/unvalid msgbox.

My problem is how to link the data typed in the form to the query?.

Cheers,
B

 

[daveUK]

You don't need to use a query for this. You can use the DLookup function instead. Search the forum, or Access help, for DLookup and you'll get plenty of answers. Also search the forum for database security/password. There are lots of threads with people asking how to password protect a database and you'll be able to change the solutions to suit your needs.