Sub Form Problems Entries Disappearing

[torquay]

Thankyou for any advice in advance.
I have a basic customer and orders database

CustomerID pk
Name
Address
City

ProductsID pk
Model
UnitPrice
QuantityInStock
Description

OrderID pk
CustomerID
EmployeeID
OrderDate
DeliveryDate
PaymentRec

OrderDetailsID pk
OrderID
ProductID
Quantity
UnitPrice
Discount

The form I am having a problem with is the customer form with the products ordered subform. The subform is based on a basic query

OrderID ProductID Description QuantityInStock Quantity
OrderDetails OrderDetails Products Products OrderDetails

UnitPrice Calculated total
OrderDetails

Here is the problem
I enter the customer in the main form and products the customer has purchased in the subform, all goes well and everything adds up nicely, even the invoice prints out correctly. If I enter in another customer or close the form and then go back into it later, some of the customers products have disappeared from the order.
When I check the order details and orders table, all of the products that I chose on the subform are showing up just fine. So I am at a loss why they are not showing up on the subform when I go back into the customers info?
Hope you have enough information here to help.
Thanks

 

[torquay]

Managed to sort it out by running the analyze performance button and this fixed the problem. Hopefully this will help if anyone else gets the same problem.
Kim