If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can't leave field if it's used to modify another?
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? |
#2
|
|||
|
|||
Can't leave field if it's used to modify another?
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. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "RG" wrote in message ups.com... 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? |
#3
|
|||
|
|||
Can't leave field if it's used to modify another?
Perfect! Thanks for your help.
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Form, Subform, Tab key | 2nd_Stage_User | Using Forms | 17 | August 25th, 2006 12:30 AM |
Help to merge Image (Doug Robins?) | JohnB | Mailmerge | 21 | June 23rd, 2005 05:28 PM |
Design help, please | SillySally | Using Forms | 27 | March 6th, 2005 04:11 AM |
Syntax needed to get needed reports | Frank Lueder | New Users | 15 | January 6th, 2005 08:39 AM |
Modify Time Field | Joe | Running & Setting Up Queries | 1 | June 13th, 2004 02:10 PM |