When I delete a record, I get the above mentioned error.
I have attached a sample db so you can try it your self.
1. It has one main form, bm.
2. Main form has 2 subforms, bm_1 and bm_2.
3. bm_2 has one subform, bm_2_1.
4. When we click on the list, on current event of bm_1 is triggered, the function found in the module is called which returns a recordset which populates bm_2_1 form.
5. Open main form (bm) and you 'l see a list in the datasheet.
And on top-left a delete button with '-' in it.
6. Select one of the records and press the delete button.
Answer 'yes' to the prompt and you 'l get the error.
Is there some way to fix it?
(I tried setting the SourceObject (Forms("bm").bm_2.SourceObject = "bm_2") as suggested in some other thread, but nothing)
bm_sample_1.zip