Home Forums Microsoft Access Microsoft Access Update Field to current logged in user ID with new record command button RE: Update Field to current logged in user ID with new record command button

  • July 17, 2013 at 9:52 am

    #1633359

    Assuming your New Button name is "cmdNew" and your UserID Textbox Name is "txtUserID":

    In the cmdNew_Click event, after the recordset is placed on the new record, add the code:

    Me.txtUserID = Environ("USERID")