J
Jerry Kogan
When a user selects a new record on a form that has a
subform, the subform does not immediately clear. It seems
that the record is not immediately inserted into the
parent table, and the parent table pointer is still on the
previous record, so even with a subform requery in the
form's on current event, the subform doesn't clear until
the after insert event of the main form. In addition to
confusing the user, it is possible for the user to delete
records in the subform, thinking they are part of the new
record, and then find out that she has deleted the subform
records that actually belong to the previous record. Is
there something I should be doing differently, or do I
have to write a lot of code in the form's oncurrent event
to work around this?
subform, the subform does not immediately clear. It seems
that the record is not immediately inserted into the
parent table, and the parent table pointer is still on the
previous record, so even with a subform requery in the
form's on current event, the subform doesn't clear until
the after insert event of the main form. In addition to
confusing the user, it is possible for the user to delete
records in the subform, thinking they are part of the new
record, and then find out that she has deleted the subform
records that actually belong to the previous record. Is
there something I should be doing differently, or do I
have to write a lot of code in the form's oncurrent event
to work around this?