Avatar of tpigielski
tpigielski
 asked on

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

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
Microsoft Access

Avatar of undefined
Last Comment
Hamed Nasr

8/22/2022 - Mon
Rey Obrero (Capricorn1)

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/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
ASKER CERTIFIED SOLUTION
Hamed Nasr

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck