Hi All,

I have a form (A) with a subform (B).
The subform gets loaded with:

MyID = Forms![FrmTabelTotaal].[subFrmTabelTotaal]!ID
NewQuery = "SELECT * FROM Tabel_Aanvragen WHERE [ID]=" & CInt(MyID)
Forms![Tabel_Aanvragen].Form.RecordSource = NewQuery

Now when I click a button on my form (A) it opens a new form where I
can add a new record.
When I close the form and add the record I want it to show in my
subform (B) but I don't know how.

Regards,
Marco

"Co" <vonclausowitz (AT) gmail (DOT) com> wrote

Add this code to the Close event for the add record form:

Me.Dirty = False
Forms![Tabel_Aanvragen].Form.ReQuery