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

  • Mr Brush,

    The line of code is definitely not executing.

    I added break on all errors and the vb editor doesn't pop up.

    Also if I set the default value of the property for the txtUserID box to Functions/Built In Functions/Database =CurrentUser() then create a new record it writes it as Admin in the text box. I am not logged into the database nor my computer as Admin so I'm not sure where it is pulling this data.

    Please let me know if you have any other thoughts?