<div>
Try this:<br />

<pre><code id="code-20-39560487-1">DoCmd.Save(acForm, &quot;NameOfFormToSave&quot;)</code></pre>
</div>


Try this:


DoCmd.Save(acForm, "NameOfFormToSave")

<div>
it is telling me the form isn't open but it is open. &nbsp;I need to save the record. &nbsp;Would I use acForm to save the record as well?
</div>


it is telling me the form isn't open but it is open.  I need to save the record.  Would I use acForm to save the record as well?

<div>
If you just want to save the data, you can try this:<br />
<br />

<pre><code id="code-20-39563365-1">Form_FormMain.subformMain.subformMain.dirty = false</code></pre>
</div>


If you just want to save the data, you can try this:



Form_FormMain.subformMain.subformMain.dirty = false

<div>
it doesn't recognize dirty as a property and generates an error. &nbsp;Also, am I writing the sub form name twice as you have above?
</div>


it doesn't recognize dirty as a property and generates an error.  Also, am I writing the sub form name twice as you have above?

<div>
This solution actually worked for me. &nbsp;I posted it to help anyone searching.
</div>


This solution actually worked for me.  I posted it to help anyone searching.

<div>
<div class="content wysiwyg-content">
I have a form (FormMain) and a subform (subformMain). &nbsp;I am trying to execute a command while in FormMain but cannot get it to work until the data in subformMain is saved. &nbsp;I can press a SAVE button in the subform and all works fine but I would like to automate this. &nbsp;I would think it would be something like:<br />
<br />
Form_FormMain.subformMain.<wbr />runcmd save.... &nbsp; I know that is wrong but the concept is there.<br />
<br />
Is there a way to run the save procedure from another form?<br />
<br />
Thanks
</div>
</div>


I have a form (FormMain) and a subform (subformMain).  I am trying to execute a command while in FormMain but cannot get it to work until the data in subformMain is saved.  I can press a SAVE button in the subform and all works fine but I would like to automate this.  I would think it would be something like:

Form_FormMain.subformMain.runcmd save....   I know that is wrong but the concept is there.

Is there a way to run the save procedure from another form?

Thanks

Run Save command from one Access form to another

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.