Error message closing subform with graph in access 2000

[AccessDevJunior]

hya,

i have a form which has a subform embedded joined together by 'date' field.
when i close the form i am getting an error meessage:

The object is locked so any changes made will not be saved,
Click save as/export on the file menu and save the object under a different name.

i beleive it is something to do with the subform containing a graph but not sure what it is causing it.

this only happens in access 2000, in access 2003 the form close's without displaying an error message.

if anyone knows how i could banish the error message it would be a great help

 

[Troyston]

Try closing the form with the AcSaveNo or AcSaveYes option and see how that changes things.

Sometimes this can happen when the form is based on a multi table query and the recordset type needs to be set to Dynaset(inconsistent updates).

Give it a whirl

 

[AccessDevJunior]

thankyou for the reply,

ive set my form and subforms to dynaset(inconsistant updates)
and ive put the code on the 'OnClick' event (to close the main form);

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveNo, , acMenuVer70

im still getting the error message coming up, not sure if i have wrote the code is correct,
any chance you could give me a few pointers on how to write this as the error meg is now becoming a real pain?