Not enough room on continuous subform for records

[Chad]

I've setup a form to enter a monthly forecast into by vendor. In order to
get the form to be user friendly and work correctly, I have 12 subforms going
across the form each subform represents a different period. The problem I'm
running into is that all the records do not fit in the space on the form.
I've extended it to 22" (max allowed in '97). I removed all the record
selectors/navigation buttons because there is not enough room to display all
of them nor do I want the user to change the selection 12 times. Is there
anyway I can display all the records in a clean easy to use format??
Hopefully I've provided enough information.

 

[Roger Carlson]

You could create a Tab Control on your form and put each subform on a
separate tab. Much cleaner.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Chad]

Well I need them to all be next to each other for visibility. I've included
a link of what the form looks like. The underlying table/query is setup so
that each vendor has a separate record for each period.

So...

002 Period 1
002 Period 2
002 Period 3 etc

http://picasaweb.google.com/Brown82781/WorkFiles?authkey=OzdOE9xaIHk#5242230625076025938

 

[John W. Vinson]

Well I need them to all be next to each other for visibility. I've included
a link of what the form looks like. The underlying table/query is setup so
that each vendor has a separate record for each period.

So...

002 Period 1
002 Period 2
002 Period 3 etc

Chad, how would you do this in Word or Excel?

You simply have *too much information on the screen at once* to be humanly
comprehensible.

 

[Chad]

Well it's currently in Excel and we're converting it to an Access database
because the Excel file is too big (currently 85MB) and to integrate it with
some of our systems. This form is only used for vendors with special
calculations (removing certain amounts from purchases, etc). There are
usually less than 15 of these. I'm trying to create something that is easy
to key in the special changes. Only the checkboxes and yellow fields are
updateable. All other fields are locked/calculations.

I guess I can just use a drop-down, they'll only be able to update one at a
time, but they'll have to work with it