Prev: Overriding constraint violation message
Next: Duplicate Record command
From: El Thicko El on 21 Apr 2010 05:06
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?
From: Avid Fan on 21 Apr 2010 06:09
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?

From: Daryl S on 21 Apr 2010 09:19
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?
 | 
Pages: 1
Prev: Overriding constraint violation message
Next: Duplicate Record command