<div>
In general to save form changes, DoCmd.Save acForm,&quot;frmName&quot;<br />
<br />

</div>


In general to save form changes, DoCmd.Save acForm,"frmName"



<div>
That works for the MainForm, but it's not working for the SubForm on the MainForm as the SubForm is only a object on the MainForm<br />

</div>


That works for the MainForm, but it's not working for the SubForm on the MainForm as the SubForm is only a object on the MainForm


<div>
<div class="content wysiwyg-content">
How do I save a Subform design change via vba ?<br />
Subform is Datasheet view, changes are made via vba, and I want to save these subform design changes.<br />
The main code changes ConditionalFormatting on the subform, and it is these changes I want saved.<br />
MS Access environemts 2003 and greater.<br />

</div>
</div>


How do I save a Subform design change via vba ?
Subform is Datasheet view, changes are made via vba, and I want to save these subform design changes.
The main code changes ConditionalFormatting on the subform, and it is these changes I want saved.
MS Access environemts 2003 and greater.


Save Subform design changes

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.