I have an AfterUpdate event for a control that exists on a subform (continuous form). The Afterupdate code recalculates controls for the current record. In order for the update to the table to take place, it appears that I need to do a Refresh. My problem is that after the Refresh, the Focus repositions itself to the 1st tab position on the subform. (I am using the Refresh so that the Table update takes place, unless there's another method available) (Access 2002 'adp')
eg. Change is applied to Control3 on subform
Use Tab to advance to next field (Control4 on subform)
AfterUpdate event fires for Control3
After REFRESH, focus is now on Control1 instead of Control4
The problem lies in knowing what the next control is. For example, they may have clicked the SAVE button instead of using the tab key, or they could also use the down arrow in the continuous form. Is there a way to bypass the refresh, or does that actually update the underlying table?