I have an auth table in an Access DB which allows users to access only their own data. Currently, all usernames are tied to department names.
I would like to have the Department Name automatically populated based on username when a user selects the Add New option.
Any assistance you can provide would be greatly appreciated.