I have a global variable called g_dblConversion that saves the conversion rate from a seperate form for use in the order form.
On the order form I have a list price box which pulls the list price from the table on which I have placed the following on before update:
Me.TxtListPrice.Value =...