automatically assign user when adding a new record
Posted on 2014-01-28
Using Access 2010. Wondered if there's a way that when a user clicks the 'Add Record' button to add a new record, it could automatically place their name into a field called 'user' which is invisible to the user but is used so as to keep a record of which user is adding the data. I could therefore create a report to show which users have added the data. I'd rather it be automatic rather than the user having to select their own username each time they add a new record if that's at all possible. I'm assuming you'd need a login form first where the user gets to choose their username (but no password). It would have to some how remember their username for every form they access and add data too. Is this possible?