inputting a calculated value into a table

[mike_980]

I wasn't sure whether this should go into the queries or forms section sorry so I just put it here.

I have a form where it is necessary for the user to input number of tanker loads, however I would ideally like the table to store the information in m3 which means multiplying whatever the user inputs by 11.3.

My plan was to use an unbound textbox for the user to input the "number of loads" into, then use a query to calculate the value and then a Dlookup to update the value of a control which will be hidden somewhere on the form. I got as far as making the query however then realised that it won't let me add an unbound textbox to a query in order to form an expression. How would you go about this? I'd like to stay away from the inbuilt "calculated field" option just in case i need to downgrade to an earlier version than 2013 at some point.

[mike_980]

Solved!

I used an unbound textbox and used the following code in after update:

Me.Quantity_spread.Value = (Combo14.Value * 11.3)

Works perfectly.