How do I trigger an event on opening a record

  • Thread starter Thread starter Geoff Budd
  • Start date Start date
G

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
 
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
 
Thanks Rob, that worked fine.

Regards,
Geoff

Rob Parker said:
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
Click to expand...
 
Back
Top