Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Location
    Oakland, CA
    Posts
    126

    Unanswered: Tracking User and Time on Form

    This is probably very easy but I'm getting stuck on the form when I finish my code. I'm trying to track the user and time when data is created and then when it's updated. So, I'm going to have 4 fields (UserInput, TimeInput, UserUpdate, TimeUpdate).

    I've tried in the form_AfterUpdate to write code
    TimeUpdate = Now()
    UserUpdate = GetUser() 'I have my function to get the user

    It works and data gets entered, but that doesn't let me go in between the records (don't know why, probably an infinite loop). PLEASE HELP. Thanks

  2. #2
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    Have you tried breaking the code? Use Ctrl-Break to see if some code is running. If it's an infinite loop then you will be able to see where.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •