Subform

J

Jody

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.
 
K

Ken Snell [MVP]

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.
 
J

Jody

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
 
J

Jody

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?
 
K

Ken Snell [MVP]

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.
 
Top