storing user id in continuous form

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
you need to make sure that your useridupdate field is bound to a field in
the table behind your frmemployeesearch.
 
Back
Top