This topic is locked

Default Value Based on Username

6/3/2004 9:25:25 AM
ASPRunnerPro General questions
A
aontech author

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.

Sergey Kornilov admin 6/3/2004

Hi,
you just need to remove Department Name from the Add page to enable auto-population of this field.

500127 6/3/2004

Worked great. Thanks.