Totals in form without query

Danielf

Registered User.
Local time
Today, 08:02
Joined
Feb 21, 2000
Messages
103
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
 
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.
 
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
 
It is a public variable coming from another
table and another form
I was thinking to write a function to
see the result.
 

Users who are viewing this thread

Back
Top Bottom