A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Sub forms keep turning out like tables



 
 
Thread Tools Display Modes
  #1  
Old April 21st, 2010, 10:06 AM posted to microsoft.public.access.forms
El Thicko
external usenet poster
 
Posts: 1
Default 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  
Old April 21st, 2010, 11:09 AM posted to microsoft.public.access.forms
Avid Fan
external usenet poster
 
Posts: 30
Default 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  
Old April 21st, 2010, 02:19 PM posted to microsoft.public.access.forms
Daryl S[_2_]
external usenet poster
 
Posts: 881
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:01 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.