Can't leave field if it's used to modify another?

  • Thread starter Thread starter RG
  • Start date Start date
R

RG

I have a simple Access 2000 form displaying multiple records in a
tablular (continuous form) format. I have an Exit procedure on one
field that checks if it's changed; if so, it updates the value of
another field.

All's fine if I Tab or Enter to leave the changed field, but if I use
the mouse to move to another record focus stays on the original field.
(And I'm never setting Cancel in the Exit procedure). Any ideas?
 
Could you use the AfterUpdate event of the control?

That fires only if the user changed the value, and is less likely to mess
with the focus issue.
 
Back
Top