After Update To Enter Data Into Another Field

[Guest]

I have a field, EnteredBy, which I want to up-date with the use ID of the
person logged on to the computer.
I use this in the Default Value, =fOSUserName() to enter the user as the
record is created.
My question is, after the record has been created, how can I initiate the
UsedID to be entered, from the After Update event from another field within
the same form.

Regards
Nick

 

[Guest]

Hi Nick,

If you mean how you can update the field with the user who last updated the
record, you could put code behind the forms After Update event like this:

me.UpdatedBy = fOSUserName()

If you meant how to do it programmatically on the creation of a new record
(instead of using a default value), you would put the same code behind the
Before Insert event of the form.

Hope this helps.

Damian.

 

[Guest]

Not quite,
The record has been selected using a query and has partially been completed.
This part of the record is to be completed by another person so I want to
automatically record who entered this section of the data. It only needs to
be recorded once. It doesn’t need to be up-dated if changed later.

I hope this makes sense.

Nick