View Full Version : Totals in form without query


Danielf
03-17-2000, 04:48 AM
I have a form with 3 Text boxes.
When I am adding a new purchase, I am filling
in textbox1 the quantity, in textbox2
the price per unit.
After having filled textbox2, I would like to see the total of (textbox1*
textbox2) without having to use a query
I have tried with Event afterupdate textbox2
but it doesn't work

Thanks

Daniel

cinnamoncw
03-17-2000, 07:41 AM
You should be able to create a text box with the formula in it. Place a new text box on you form. Under properties, type your formula in the Control source box: =[field1]*[field2]
After entering over field2, your new field box will display the total.

Danielf
03-17-2000, 10:50 AM
Hi,
I forgot to write something
This-about =[field1]*[field2]-
I knew but my problem is :
I would like to add to textbox3 the value
of a variable like
[var]+([field1]*[field2]) and this doesn't work
Daniel

cinnamoncw
03-17-2000, 11:19 AM
Where is the variable coming from?

Danielf
03-17-2000, 12:56 PM
It is a public variable coming from another
table and another form
I was thinking to write a function to
see the result.