<div>
Me.frmSub.Form.RecordSourc<wbr />e = &quot;SELECT * FROM YourTable&quot;
</div>


<div>
Thanks for the grade. &nbsp;Good luck with your project. &nbsp;-Jim
</div>


<div>
<div class="content wysiwyg-content">
I have a subform with the name of &quot;frmSub&quot;<br />
<br />
From a button on main form, I have the following code error out:<br />
<br />
&nbsp;Me.frmSub.SourceObject &nbsp;= &quot;&lt;&lt;table name&gt;&gt;&quot;<br />
<br />
I tried this exact code in a smaller, sample DB and worked fine. &nbsp;Moving it over to another one I get an error.<br />
<br />
<br />
ERROR: &nbsp;The setting you entered isn't valid for this property
</div>
</div>


I have a subform with the name of "frmSub"

From a button on main form, I have the following code error out:

 Me.frmSub.SourceObject  = "<<table name>>"

I tried this exact code in a smaller, sample DB and worked fine.  Moving it over to another one I get an error.


ERROR:  The setting you entered isn't valid for this property

Me.frmSub.Form.RecordSource = &quot;SELECT * FROM YourTable&quot;

Thanks for the grade.  Good luck with your project.  -Jim

MS Access error on subform

I have a subform with the name of &quot;frmSub&quot;

From a button on main form, I have the following code error out:

 Me.frmSub.SourceObject  = &quot;&lt;&lt;table name&gt;&gt;&quot;

I tried this exact code in a smaller, sample DB and worked fine.  Moving it over to another one I get an error.


ERROR:  The setting you entered isn&#39;t valid for this property

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.