If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sub forms keep turning out like tables
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? |
#2
|
|||
|
|||
Sub forms keep turning out like tables
On 21/04/2010 7:06 PM, El Thicko wrote:
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? |
#3
|
|||
|
|||
Sub forms keep turning out like tables
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. -- Daryl S "El Thicko" wrote: 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? |
Thread Tools | |
Display Modes | |
|
|