Sub forms keep turning out like tables

E

El Thicko

I am new to Microsoft Access 2007. I am trying to create subforms that relate
to tables I have created. I add the fields relevent to the forms and in
design view it actually looks like a form (which is what I want) yet in form
view it is in the form of a table. This is doing my head in. Also should I be
able to sort this problem out how can I link all the subforms to the same
item from differant tables?
 
A

Avid Fan

I am new to Microsoft Access 2007. I am trying to create subforms that relate
to tables I have created. I add the fields relevent to the forms and in
design view it actually looks like a form (which is what I want) yet in form
view it is in the form of a table. This is doing my head in.

If you click on the subform. Click on the property sheet in the "Design"
Ribbon.

Click on the on the corner of the subform or select Form objects in
property sheet. Under the format tab select "Default View" and change
it from Datasheet to Single form.


Also should I be
able to sort this problem out how can I link all the subforms to the same
item from differant tables?

I don't understand it?
 
D

Daryl S

El Thicko -

Are you really putting the subforms on a form? If so, you link the subform
to the main form with the parent-child relationships. This comes up
automatically when you add a subform to a form. If it is already there,
select the subform and check properties for the parent/child links. Now when
you change a record in the main form, the subform will only show related
records.

If you are calling this a subform, but opening it as its own form from
multiple other forms, then you can open the subform, showing only the related
records, by passing in the criteria on the OpenForm command. This is not a
link, so if you change the main form, the "subform" that is open by itself
will not update. Look up the OpenForm command for help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top