Parent Child Transaction

[deepak_r_patel]

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.

[Judgey]

How are you deleting the records from the Child Table ?, I had the same problem as I was using code to delete records from the child table and then from master.

I resolved it my setting up the one to many relationship in access and the cascade delete related records. then I only had to delete the record from the master table and Access did the rest.

[deepak_r_patel]

I was able to delete my records but then while going to the other record the child recordset was giving a problem. Anyway the problem is already solved.