navigation control subform saving

[spinkung]

Hi

i've had this a few times now so it's a real pain. Access 2010.

one of the forms i load into a navigation form is in datasheet view and some vba re-sizes all the columns as it loads in.

However, this then means that when i try to navigate away to another form i always get prompted whether to save the form or not.

because the form is in a navigation subform i can't use:

DoCmd.Save acForm, Form_NavigationForm.NavigationSubform.Form.Name

' or this...

DoCmd.Save acForm, "my_form"

in both cases i get an error : the object my_form isn't open

can anyone let me know how to avoid this as it's confusing for users.

Thanks

 

[Mihail]

An idea: try to ave the form after the vba finish to re-size that columns.