G
Guest
I'm sure you answer this over and over again. I did search first and found
not a suitable answer...
I have a header table and detail table linked by ID. In a form, I launch
another form that adds a header and creates loads of detail. I close that
form and return to the caller form. The Caller form shows the header and
detail in a form/subform format, which works.
When I get back to the Caller form, he can't see the new added header
record. If there were four records when he called the Add form, there are
still four records, even though the Add form may have added several headers.
I have fired the me.requery method on GotFocus for the Caller form. No joy.
I've fired the me.refresh method as well. No joy. I literally have to close
the Caller form and reopen it to see the new header record(s).
Only strange thing (if one considers it strange...) is that I'm using ADO to
update the header (and detail) tables.
Record source for the caller is only the header table. No filters or sorts.
Ideas?
TIA -- Jim
not a suitable answer...
I have a header table and detail table linked by ID. In a form, I launch
another form that adds a header and creates loads of detail. I close that
form and return to the caller form. The Caller form shows the header and
detail in a form/subform format, which works.
When I get back to the Caller form, he can't see the new added header
record. If there were four records when he called the Add form, there are
still four records, even though the Add form may have added several headers.
I have fired the me.requery method on GotFocus for the Caller form. No joy.
I've fired the me.refresh method as well. No joy. I literally have to close
the Caller form and reopen it to see the new header record(s).
Only strange thing (if one considers it strange...) is that I'm using ADO to
update the header (and detail) tables.
Record source for the caller is only the header table. No filters or sorts.
Ideas?
TIA -- Jim