I have a continuous form (no subforms) which has a query (with several linked tables) as the record source. I tested to query to be certain that it is updatable! It is. The form properties indicate the form is editable.
When I edit one or more fields in the form and attempt to move to another record, the form locks and I cannot move off the edited record. Hitting "ESC" a couple time unlocks the form, the updates are lost and I can move to another record.
I have attempted to save the record on "AfterUpdate" of an edited field and cannot do so.
Any ideas as to what I'm doing wrong?
Thank you in advance for your courtesies.
When I edit one or more fields in the form and attempt to move to another record, the form locks and I cannot move off the edited record. Hitting "ESC" a couple time unlocks the form, the updates are lost and I can move to another record.
I have attempted to save the record on "AfterUpdate" of an edited field and cannot do so.
Any ideas as to what I'm doing wrong?
Thank you in advance for your courtesies.
