form size

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

Guest

i got a table with 240 diferent products
my form is to small to show them all, and i using allready the 55 cm
allowed. It as to be big enoght, sow the scroll bar will not appear, because:
the problem is that:
my table as the fields: Main Date, Product Code, Quantity.
my form as to be like this: Product Code, Quantity (Main Date), Quantity
(Main Date+1), Quantity (Main Date+2). to do this form i have done 3 diferent
querys and get them all into 1 query. But, this way i won't be able to change
the quantity in the form.
i will be able to change if i do 3 subforms, but, because the form can't be
bigger then 55cm, the scroll bars of the subforms won't work at the same
time. i defenily have to avoid that.

i hope you understand.
i need the form to be bigger then 55cm or a way to work the scroll bars to
work at the same time

thank you
 
Not clear at all what you are trying to do. What is the purpose of the
database? What does "Quantity (Main Date)" mean? Why are you adding to that
number? If you have a subform (or subforms) that points to a table
relationship you have not described. More information is needed.
 
Roy,

Is it a requirement to be able to edit the Quantity in any of the 3
quantity columns on the form?
 
Back
Top