Problem Printing A record

Hello Experts

I have a problem with printing a record with a sub-form section.

I have a "Quotation" form I print and send to customers.

The form incorporates a "Product Detail" subform with a line by line
description of services and cost.

When I select and print the record, the Product Details are not always in
the same order as they appear in display. I have tried fiddling with Sorting
& Filters and sometimes I can get the record to print as it appears but I am
not sure what triggers the problem or the solution.

Here is a typical example:
Quotation
Sand Down And re-Hang Doors:
Court Room 1 £350
Court Room 2 £350
Court Room 3 £400
Court Room 4 £420

When Printed
Quotation
Court Room 4 £420
Sand Down And re-Hang Doors:
Court Room 1 £350
....etc

Dosen't appear to follow any particular pattern that I can see and worse it
seems random, some records print fine others get jumbled.

The databse has multiple users so perhaps someone is doing something they
shouldn't?

Would dearly appreciate your comments.
Brian



Court Room