VBA script to validate user entry to access database

Hello All

I'm trying to add an auto-login function to a database, that will recognise users already logged in to the network through a VBA script that will:

1 - Recognise the user details trying to gain access to the db (using the environ variable)
2 - Validate their details against the table of registered users
3 - If they are listed, allow them access, If not exit the app with an approprate message.

I have got so far with this but cannot get the script to work properly.
Can anybody help me please?

For clarity:

TblStaff is the table containing staff data

Within the table:

Staff_Number is the field being searched to validate the entry
Current is a ticked-box field confirming that the staff member is working on the correct team

Please Login or Register  to view this content.