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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Form - Lock Fields from Editing 0
setfocus on form control, not subform 4
Defaulting fields 1
Pivot table/chart in subform - can't open Field List 3
Add New Record Button: How to Get Mouse Cursor in Specific Field Upon Clicking? 1
First Subform record gets modified when closing form 3
Validate the number of checkboxes that can be true 0
Can a Check Box Prevent Other Fields from Being Used? 1

Back
Top