Calculation In Text Box

[James Tebb]

I have an order form which has a List Box showing Unit Price and a combo box that displays Quantity.
I want a text box to calculate the Line Total eg Unit Price x Quantity. This text box will be bound to a column in the underlying table

Any Ideas

 

[Joe4]

This text box will be bound to a column in the underlying table

Why? If you can calculate it, there should be no need to physically store it in an underlying table. Actually, it violates the rules of data normalization to do so.

One way of doing this is to create the formula in a query, and base your form off of the query. The text box can be bound to the calculated field in your query.

 

[James Tebb]

Thanks Joe - Makes Sense
Just tried to create the query but get #name
How exactly should I create the query

 

[Joe4]

Create a new query and add your fields to the query.
Then, create your calculated field. It might look something like this:

LineTotal: [Unit Price] * [Quantity]

(obviously, you may need to change your field names if they are different)

Then, use the LineTotal calculated field in your Form. If you display the Field List, you can just click and drag the field to where you want it on the Form.