display continuous records side by side on form

A

Andi Lee Davis

I have a subform for Customer Business Partners
The Subform is linked by CustomerID to the Main Form so only the related partners to that customer show
However I would like to display those Partner Records Side by Side across the page and not down the page as it usually does. This is because my main form has to look like the original paper one and it is running out of space.
We need this in order to fax proposals accross to our third party

Does anyone have an idea how to adjust the way records are displayed on a form in this mannor

Cheers, Andi
 
P

PC Datatsheet

You need to base your subform on a crosstab query.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com


Andi Lee Davis said:
I have a subform for Customer Business Partners.
The Subform is linked by CustomerID to the Main Form so only the related
Click to expand...
partners to that customer show.
However I would like to display those Partner Records Side by Side across the
Click to expand...
page and not down the page as it usually does. This is because my main form has
to look like the original paper one and it is running out of space.
 
A

Andi Lee Davis

Yeah thought of that but when I did that I had
CustomerID - RowHeading
PartnerID - ColumnHeading
Name and AddressDetails - Value (Expression - (address1 & address 2 & address 3 etc..)

It said I couldn't have an expressionin as the Value.
 
Top