Print Preview not same as Form View

[WilsonDC]

I am using tblCustomers as master for clients info and using iform to collect data in the field and import it into another tblCustomerSub. I created a frmWorkOrder and displayed clients from tblCustomers and additonal information from tblCustomersSub in 2 subforms. It all works in form view, but when I click print preview, one of the subform runs as continuous when it is set as single form.

one subform display data in a form view, the other subform displays selected data in datasheet view.

tblCustomers is source for frmWorkOrder
tblCustomersSub is source for frmWorkOrderHistory (datasheet view) and frmWorkOrderInfo (Single form)
base on record in tblCustomers records are shown in subforms from tblCustomersSub.

Again, all is fine in Form view, but when i want to print one form pertaining to one record in tblCustomers, it wants to print all the records pertaining to that record from tblCustomersSub and my form goes from one page to 4 or 5 depending on number of linked records.

My question is basically to know if this sounds like a form issue or a linking tables issue.

I still cant grasp VBA so if you suggest using anyof that, i may get lost.

 

[pbaldy]

Most of us recommend printing reports rather than forms. You have a lot more control over the look and format. I often use this technique to restrict a report to a given record:

http://www.baldyweb.com/wherecondition.htm

 

[WilsonDC]

I will look at making a report then to print based on what you have mentioned. Thanks.

 

[pbaldy]

No problem; I think you'll be happier in the long run. Post back if you get stuck.

 

[WilsonDC]

I went back and created a report and had the same problem. However, after trial and error, I found in the properties in format section a 'can grow' option. I selected 'no' and it fixed it. Not sure if this is helpful to anyone but anyways, Thanks to everyone.