printing problems with subforms

[stevie1969]

I have a form that includes a subform. The screen view and the print preview show the subform data ordered according to a field 'number' - this is correct. However when I actually print the form the subform is ordered according to the order I entered the data - I guess the primary key ID.

Why is this?

 

[edtab]

In design view of the report, right click anywhere
and choose sorting and grouping. This is where you
control the sort order of your subform.