Lookup unbound textbox value in table

[Miff3436]

Hi all,

I have a form that I use as my switchboard for my access 2010 db. I have an unbound textbox that picks up the current users name using the environ username on the load event. This textbox is not visible to the user.

I have a table called "access users" that I enter the staff's names who I want to access the db. I enter their names as it will appear in the environ username unbound textbox on my switchboard. From here is there a way I can get the value in the text box to look up the names in "access users" table ? If it finds an exact match the next form opens as it should and if there is no record in the table against the form textbox value then a message box appears and the user cannot progress any further.

Thanks for. Your time
miff3436

 

[vbaInet]

Welcome to the forum Miff3436.

You can accomplish this using a domain aggregate function such as DLookup() or DCount() in a conditional IF..ELSE..END IF block.

Here's a link for the functions:

http://www.techonthenet.com/access/functions/