Triggering event when entering record...

[Bill Mitchell]

Hi,

Is there some way to trigger and event when i enter a
record on a continuous form and trigger another event
when I leave that record? This seems like it should be
available but I'm not seeing it anywhere.

It seems like OnCurrent works great for entering the
record but how about when leaving?

I want to check a bound box when i enter a record on a
continuous form and uncheck it when i leave. sounds
simple enough.

Bill

 

[tina]

have you tried the form's BeforeUpdate event? it's
triggered automatically when you exit a record in the
form, so it may give you the result you want.

hth

ps. re form events GotFocus and LostFocus, here's a
snippet from the Access Help file:
"A control can receive the focus only if its Visible and
Enabled properties are set to Yes. A form can receive the
focus only if it has no controls or if all visible
controls are disabled. If a form contains any visible,
enabled controls, the GotFocus event for the form doesn't
occur."