I built an order form for my company in Forms ( here's a screenshot of it in design view) and I need to write a simple expression to total up the price in each row. I don't need the information saved anywhere so I left the fields unbound, but is it even possible to write expressions for unbound fields? I just need the quantity row * the price each row so I get a total. I know how to get it to work with the fields linked to tables with a relationship but if I do that the form looks messy, and we need this to send out to customers. Any thoughts?

Edited by: Stellae on Fri Dec 21 12:28:33 EST 2007.

Yes, just set the control source of the unbound control to the calculation you want it to perform.

For instance

=[Quantity] * [Price]

where [Quantity] and [Price] are controls on the form.

I made the first quantity box "qty1" and the first price box "price1" and in the total box wrote =([qty1]*[price1]). but I just get the "#Name?" error message

Are qty1 and price1 the names of the controls on the form?

I get the same #name? in my unboudn text field
me.sdescription= "plane description" doesn't work