I have a main form, which contains a subform which lists information relating to orders. The main form contains customer details.

When I create a new order for the customer, a new blank order form is opened. Once I input the data and save it, there is an option to print the order from the order form. When the print preview is closed, MS Access inherently refreshes the new order form, and loads / shows the previous order number, instead of the new order number that was just created somehow.

From what I can gather, on the main form (and the sub form on the main form), the record pointer is on the previous order, and therefore the new order form is reflected to show this record when I close the print preview.

How do I stop this behaviour? I have read that this could possibly be a behaviour of access, but I am hoping that there is a way around it.

Any assistance would be appreciated.