I have a parent-child relationship on the form. When I try to delete a record, I am able to delete records from both Parent and child tables and then when I move to next record in the master table and retrieve the child records for that particular master record, I am getting an error 'An object was open'. The state of the recordset is being shown as close. If I write On error resume next it works fine but ot doesn't show the child records for the master record.

Please help me as I am stuck in this problem.