Saving through Code

[JDU]

I have a subform that changes. How can I save it through code before closing.

When I use the command:
docmd.save acForm, FormName

I get the message that the subform is not open; however, the subform is open on the form.

Am I missing something

Thanks

 

[kraxmo]

docmd.save acForm, FormName

will only work on the form (not subforms). Try using the following code in the main Form's On Close event:

    Me!subformcontrolname.Form.Refresh

Replace

subformcontrolname

with the actual subform control name (NOT the subform's name in the Database window) used on your form.

Note: the Refresh method will complete any pending form updates. Jim Kraxberger
Developing Access solutions since 1995

 

[JDU]

The above suggestion didn't work. Maybe I should be more clear. I have 3 subforms on a form whose txtbox names and controlsources I change via code. Consequently when I go to close the form, I am prompted to save the 3 subforms.

I would like this to happen via code and therefore no prompting.

Does this help?

Thanks

 

[JDU]

Does Anyone have a suggestion on this?

Thanks