Delete records in subforms

[BillyL]

I have two subforms (sfrmCalls and sfrmNotes) in a form (frmCallLog) both subforms are from a single table. The only way I could get them to synchronize and work was to add the CallID field to the sfrmCalls form (Visible=false) and make it the master link for the sfrmNotes.
Here is the subform setup:

sfrmCalls: Child=ContactID; Master=ContactID
sfrmNotes: Child=CallID; Master=forms!frmCallLog!sfrmCalls!CallID

This seems to work satisfactory but if I select and delete a record from sfrmCalls, then "#deleted" appears in the sfrmNotes form and Access stops responding.

Any help with this would be greatly appreciated.

 

[Darrylles]

Hi,

Not sure, but try Addnew after the delete, or Refresh.
(Are you 'Update' ing after the delete?)

It needs to point to a new 'null' record - ready for editing.

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk