I have a form with three controls : Order Id, Customer Name, Invoice Total.
Order ID is a combo box
This form is linked to the table "TblFinance"
The form is used when Customers pay for their orders.
I am using a DLookUp to get the Invoice Total and Customer Name based on the Order Id I select from the combo box.
The problem i have is that, immediately the items appear on the form, the Table "TblFinance" is automatically updated when the user has not Validated the entry.
What can i do to make sure that the control items stay in the form until the user clicks the OK button?
Thanks in advance for your help.