Run Time Error 3197

[atrium]

I keep on getting this error after I have gone back to an open form and close it.

Form A displays the fields from Table DdSchedules

Form B launched from Form A displays the fields from Table DdSchedules and a subform displays related records from another Table DdSchedTrans in a query

When I close form B all is OK, it's when I close Form A I get the error

I realise Form A is open to edit and I update some fields in form A when operating in form B. In Form B I run a query to update table DdSchedules.

Any ideas to Help me overcome the problem

atrium

 

[Minty]

I think you will need to refresh / requery Form A after form B updates the records that are on it.