<div>
create the &quot;subform&quot; to be, as a form, like you normally do.<br />
when your done, save the form<br />
open the main form in design view<br />
drag and drop the newly created form to the main form,<br />
it will now be a subform,<br />
set the Master/Child link fields.<br />
<br />
or watch this demo first<br />
<br />
<a href="http://office.microsoft.com/en-us/access-help/watch-this-create-a-form-that-contains-a-subdatasheet-HA010277407.aspx" rel="ugc">http://office.microsoft.com/en-us/access-help/watch-this-create-a-form-that-contains-a-subdatasheet-HA010277407.aspx</a><br />
<br />
<a href="http://office.microsoft.com/en-us/access-help/add-a-subdatasheet-HA010266800.aspx?CTT=3" rel="ugc">http://office.microsoft.com/en-us/access-help/add-a-subdatasheet-HA010266800.aspx?CTT=3</a><br />
<br />
<br />
<a href="http://office.microsoft.com/en-us/access-help/create-a-form-that-contains-a-subform-a-one-to-many-form-HA010098674.aspx?CTT=3" rel="ugc">http://office.microsoft.com/en-us/access-help/create-a-form-that-contains-a-subform-a-one-to-many-form-HA010098674.aspx?CTT=3</a>
</div>


create the "subform" to be, as a form, like you normally do.
when your done, save the form
open the main form in design view
drag and drop the newly created form to the main form,
it will now be a subform,
set the Master/Child link fields.

or watch this demo first

http://office.microsoft.com/en-us/access-help/watch-this-create-a-form-that-contains-a-subdatasheet-HA010277407.aspx [http://office.microsoft.com/en-us/access-help/watch-this-create-a-form-that-contains-a-subdatasheet-HA010277407.aspx]

http://office.microsoft.com/en-us/access-help/add-a-subdatasheet-HA010266800.aspx?CTT=3 [http://office.microsoft.com/en-us/access-help/add-a-subdatasheet-HA010266800.aspx?CTT=3]


http://office.microsoft.com/en-us/access-help/create-a-form-that-contains-a-subform-a-one-to-many-form-HA010098674.aspx?CTT=3 [http://office.microsoft.com/en-us/access-help/create-a-form-that-contains-a-subform-a-one-to-many-form-HA010098674.aspx?CTT=3]

<div>
<div class="content wysiwyg-content">
I have a form in an Access 2007 application that I am trying to modify. &nbsp;I had a subform created on the main form, and deleted it to create a substitute subform, but now when I create the new subform, tables are not available as the &quot;source&quot; for the subform....only forms. &nbsp;Not sure what is going on here? &nbsp;If I click on the &quot;use existing tables and queries&quot; radio button, the list does not change...still show forms.<br />
<br />
Thanks for your help..<br />
<br />
Tom
</div>
</div>


I have a form in an Access 2007 application that I am trying to modify.  I had a subform created on the main form, and deleted it to create a substitute subform, but now when I create the new subform, tables are not available as the "source" for the subform....only forms.  Not sure what is going on here?  If I click on the "use existing tables and queries" radio button, the list does not change...still show forms.

Thanks for your help..

Tom

Cannot create an Access subform with a table as a source?

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.