How do I trigger an event on opening a record

[Geoff Budd]

I have an Access 2003 form where I would like to take an action (e.g. via an
event procedure or macro) whwnever the user opens a record for editing (e.g.
via the arrowed record selector buttons). Effectively what I want is
something like an On Enter or On Open control but relating to a whole record.
It seems that such a control is only available for (e.g.) a text box, which
relates to a single field in a record. I thought there would be something in
the Detail section of the form as I thought that section related to whole
records (?) but there isn't such a control there.
Any ideas would be very helpful. Thanks in advance.
Geoff

 

[Rob Parker]

Hi Geoff,

I don't really understand what you mean by "the user opens a record for
editing". Hoiwever, I suspect that what you want is the On Current event of
the form, which is triggered whenever the user moves to another record - by
any means.

HTH,

Rob

 

[Geoff Budd]

Thanks Rob, that worked fine.

Regards,
Geoff

Hi Geoff,

I don't really understand what you mean by "the user opens a record for
editing". Hoiwever, I suspect that what you want is the On Current event of
the form, which is triggered whenever the user moves to another record - by
any means.

HTH,

Rob