Thanks, I'll ive it a try! Dave
--- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > > 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/
