Password Authentication

[Guest_imported]

I'm trying to make a Form (bound to a table called User) that will look through the User table for a match with the textbox containing the username, and then check against the password in the next attribute of the record.

Any suggestions would be grateful.

 

[jhall156]

You don't really need to bind the controls to the table if all you really want to do is a lookup and then process the result. on the click event of the go button you could for instance do a DCount with the criteria from the text boxes and test the result for non zero.

 

[Guest_imported]

Thanks,

I never thought of that! I'll try it now

 

[rss01]

I had something similar we used the DLOOKUP() function that took the user name went to the user table and got the password then compared it to what was keyed in if true it opened the form.