storing user id in continuous form

[Guest]

Hi, I have a continuous form to search for employees. Edits are also
permitted from this form. What I would like to do is update the login id
for the user who updates a record on the form.

I have done the following:
in the before update of form frmemployeesearch

me.useridupdate = forms!invisibleuserid.userid

invisibleuserid is a form that is invisible to the user, but that stores the
user id after the login happens. I am using this form to update the user id
on records.

as for my continuous form, this is working, however if I edit one record,
the useridupdate field is updated for all the records rather then just the
record on the continuous form that I have updated. Is tehre a way to have
this coded so that it only updates the useridupdate field on the record that
has been edited on form frmemployeesearch?

Thank you.

 

[Lynn Trapp]

you need to make sure that your useridupdate field is bound to a field in
the table behind your frmemployeesearch.