adding two numbers and displaying a total

[ms756485]

Hi. The search function for Tek-Tips is down, so I apologize in advance if this subject has been discussed already.

I have a form that has two text boxes. In the first one I type in a number (quantity). The second box has is static and has a preset number in it (price).

I would like to add a third box that displays the total of value (box One) times value (box Two) when the value of box one is altered.

This is dead easy to do in Excel, but I have no idea how to do it in Access - unfortunately, my company insists that it is in Access with all the other database's.

Thanks in advance.

Marc.

 

[cghoga]

Within the after update event property of the first text box include the following code:

Box3.value = Box1.value * Box2.value

i hope this helps.