Blank Field automatically added in subform

[morganpeet]

Hi,

I have a master form Order Entry and a sub form Order Entry Sub Form the sub form is a data sheet so that I can add several rows of the order of different products, rates etc. The subform is linked to the main form by invoice number and customer name. However when I go to print the order the blank line on the subform prints on the invoice i.e a line of zeros. How can I get rid of that?

Also if I use the record navigation keys at the bottom of the form the subform data does not refresh and just shows blank rows although if I go to print invoice it is still there.

Many thanks.

 

[KenHigg]

For starters are you printing the form or a report. A report is the best way to print stuff.

 

[Uncle Gizmo]

You should not be printing your form, you should be printing a report. I believe if you generate a report, then many of your problems will disappear.

 

[morganpeet]

Sorry I forgot to say that I am printing to a report - any idea?