Subform does not immediately clear on new record

  • Thread starter Thread starter Jerry Kogan
  • Start date Start date
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?
 
You can try putting a button in the subform that can be
clicked on to refresh the page, or put code in that
refreshes the subform each time a new main form is added.
 
Back
Top