I have continuous form (sub-form in fact). It has 3 fields: 1 a cbo box, 2 a notes field, 3 an amount. When the user adds a field by selecting from the cbo, a VBA AfterUpdate event sets the amount. This part works OK.
The focus moves automatically to the first record - I don't know why - rather than staying on the current record and moving to the notes field.
How can I keep the focus on the this record or move it back to the current record and field 2?