Event timing

[Junior]

Using an edit form [FormEdit]- set up as single form with an unbound
[cboName] to select the record with recordset clone in afterupdate event to
move to the selected record

1. after controls are edited - i want to make sure the changes are saved.
I'm requerying the fields in the [FormEdit] Current event is that correct?
or is there a better way?
Because the controls that may be edited vary - i don't have a single control
that i'm sure will be edited every time
2. i also want to record the username and date the record was edited -
already have the code to identify the user - but given the above situation-
what event should i use to trigger saving the username and date edited??

 

[TC]

Using an edit form [FormEdit]- set up as single form with an unbound
[cboName] to select the record with recordset clone in afterupdate event to
move to the selected record

1. after controls are edited - i want to make sure the changes are saved.
I'm requerying the fields in the [FormEdit] Current event is that correct?
or is there a better way?
Because the controls that may be edited vary - i don't have a single control
that i'm sure will be edited every time

Normally, the editable controls would be bound to fields in the underlying
data source of the form. Then, the edits are saved automatically by Access
when you move to another record, or close the form. You need not (and
normally *should* not) write any code at all, to make this happen. (The data
source of the form is specified in the Recordsource propery of the form. The
field to which a control is bound - in that data source - is specified in
the Controlsource property of the control.)

2. i also want to record the username and date the record was edited -
already have the code to identify the user - but given the above situation-
what event should i use to trigger saving the username and date edited??

I suggest you get issue 1. fixed before you worry about issue 2.

HTH,
TC