Hello - have a text box for a username that when you enter the data, i want to be able to check the user name against a list of user names in a table to allow them to view something else - if that makes sense

Thanking you

I would use DAO objects to open and browse the table, comparing the entered string with the user name field in each record, and taking the appropriate action depending upon whether or not a match is found.

I'd use Dlookup to see if the name is in the other table.