Subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have my form and subform working well, except for 1 thing. I want the data
on the subform to go the other direction.

Example

What it looks like know

Name field 1 field2 field3 ext.


what I need it to look like

Name
Field 1
Field 2
field 3
ext.
 
If the subform is in Datasheet view, then you cannot do what you want.
However, switch the subform to Continuous Forms view (this is in the Default
View property of the form) and arrange the controls on the form the way you
want each record to appear.
 
This is sort of what I need, not quite.

I need to have the form look like this

Name
Mary Bob Tom
Field 1 1 5 6
Field 2 5 6 7
Field 3 5 8 7
Field 4 6 5 8
 
to make my question more clear, I have it set up better, but I want more than
1 column for each record, beside each other. How do I do that?
 
To do this, you'll need to create a Crosstab query to return the data in
this format, and then use that query as the record source of the subform's
form.
 
Back
Top