Totals in form without query

[Danielf]

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]

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]

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]

Where is the variable coming from?

 

[Danielf]

It is a public variable coming from another
table and another form
I was thinking to write a function to
see the result.