<div>
or create a form with a datasheet subform and just change the recordsource like this<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp;me.subformControlName.form<wbr />.recordSou<wbr />rce=&quot;table<wbr />1&quot;<br />
<br />
etc
</div>


or create a form with a datasheet subform and just change the recordsource like this

       me.subformControlName.form.recordSource="table1"

etc

<div>
I'm with you. &nbsp;The grid is actually a subform. &nbsp;How do I reference that subform to change the recordsource?
</div>


I'm with you.  The grid is actually a subform.  How do I reference that subform to change the recordsource?

<div>
select case frame0<br />
&nbsp; &nbsp; &nbsp; &nbsp;case 1<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; me.subformControlName.form<wbr />.recordSou<wbr />rce=&quot;table<wbr />1&quot;<br />
&nbsp; &nbsp; &nbsp; &nbsp;case 2<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; me.subformControlName.form<wbr />.recordSou<wbr />rce=&quot;table<wbr />2&quot;<br />
&nbsp; &nbsp; &nbsp; &nbsp;case 3<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; me.subformControlName.form<wbr />.recordSou<wbr />rce=&quot;table<wbr />3&quot;<br />
<br />
end select
</div>


select case frame0
       case 1
            me.subformControlName.form.recordSource="table1"
       case 2
            me.subformControlName.form.recordSource="table2"
       case 3
            me.subformControlName.form.recordSource="table3"

end select

<div>
<div class="content wysiwyg-content">
I'm looking for some guidence/suggestions on this one.<br />
<br />
I have 3 tables each in the exact same layout (don't ask why they are not in a single table)<br />
I want to create a form that has 3 radio buttons - each representing one of the 3 tables.<br />
<br />
I want to display a data grid of the associated table when the related button is selected. &nbsp;Basically allowing me to jump back and forth between the two tables.
</div>
</div>


I'm looking for some guidence/suggestions on this one.

I have 3 tables each in the exact same layout (don't ask why they are not in a single table)
I want to create a form that has 3 radio buttons - each representing one of the 3 tables.

I want to display a data grid of the associated table when the related button is selected.  Basically allowing me to jump back and forth between the two tables.

MS Access Form switiching several tables

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.