Realise this has been asked before but I'm struggling to get a subform to update it's recordset when a new record is added.
Have one main form with sevral tabs and some of these tabs I've placed subforms.
The three recordsets are linked by a one-many ID table from each of the two other tables, a primary and secondary table.
When I add an entry to the secondary table via a subform, subforms on other tabs do not update when I navigate between tabs after adding or deleting a record. However when I change records in the main form and then navigate back to the entry changed the record has been updated.
I've tried numerous requery options but none appear to work. What happens between changing records as this seems to work rather than a requery?
Any ideas appreciated.
Thanks.
Have one main form with sevral tabs and some of these tabs I've placed subforms.
The three recordsets are linked by a one-many ID table from each of the two other tables, a primary and secondary table.
When I add an entry to the secondary table via a subform, subforms on other tabs do not update when I navigate between tabs after adding or deleting a record. However when I change records in the main form and then navigate back to the entry changed the record has been updated.
I've tried numerous requery options but none appear to work. What happens between changing records as this seems to work rather than a requery?
Any ideas appreciated.
Thanks.