Unbound value looks up a table
Hi,
With the help of this group I have a form that accurately receives logon info. Problem is I looked in axs97 help & don’t find how I can take unbound text box values (code & password) & match them with whats sitting in the table file for passwords. I’m referring ofcourse to written code. Am I correct in assuming that when a match for one field is found & I do verfication purposes for another unbound field, that it will lookup against the same record found in the initial lookup for the prior field?
Thanks!

See my answer to your previous post. But to offer more explaination. The code I posted uses a query that selects based on two columns so I can give only one message. If you want to distinguish between a bad userID and a bad password. Use a query that uses only the userID in the WHERE clause. If no record is retrieved, you can display an error that the userID was not found. If a record is retrieved by the query, then you can check the password field and if it is not valid, you can display a password error message.

Refer to the password field in code (using my example) as Tempset1!yourpasswordfieldname

The column name must be qualified by the name of the recordset object which in my example is Tempset1.