Link to home
Get AccessLog in
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
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

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
Avatar of Hamed Nasr
Hamed Nasr
Flag of Oman image

Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access