Dave-
You could do it in the form's Current event, but check first to make sure
you're not on the new record (Me.Newrecord = True) if the form is updatable.
You'll probably want to also check to see that you haven't already recorded
the user name in the current session. No point in writing the user name
every time as the user moves back and forth in the records in the form. I
recommend executing an Update query behind the scenes using the Primary Key
of the record so you don't "dirty" the record on the form. Something like:
CurrentDb.Execute "UPDATE MyTable " & _
"Set MemoViewed = MemoViewed & "; " & CurrentUser & _
" " & Time WHERE MyTable.Pkey = " & Me.PKey", dbFailOnError
John Viescas, author
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
Running Microsoft Access 2000
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
For the inside scoop on Access 2007, see:
http://blogs.msdn.com/access/
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of Dave
Sent: Sunday, April 16, 2006 4:34 AM
To: [email protected]
Subject: [ms_access] Trying to set up form to record views of record
Howdy all,
Looking for some advice. I am trying to set up a form that is used to
view records that has a field that captures the username of the person
viewing the record and records it in a memo as an update on the
field. The recording of the updates and the username works fine, but
I am trying to get the update to happen automatically....any ideas,
suggestions, or examples from the group?
Dave
Yahoo! Groups Links
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
