Autoupdate calc in form

  • Thread starter Thread starter mark909
  • Start date Start date
M

mark909

Im creating a from where you type in values in two text boxes.

In a third text box ill have a calculation using the values from the two
text boxes, eg:

=[txtBox1]*[txtBox2]

Ill type the values in the first two text boxes but then ill have to change
from Form view back to design view and back again for the calculation to show.

I was wondering if there was a way to get the calculation to work
automatically or some other way of refreshing the screen without coming out
of the form? Maybe a button set up with a macro with run the calculation.

Any ideas?

Thanks in advance for help!
 
Im creating a from where you type in values in two text boxes.

In a third text box ill have a calculation using the values from the two
text boxes, eg:

=[txtBox1]*[txtBox2]

Ill type the values in the first two text boxes but then ill have to change
from Form view back to design view and back again for the calculation to show.

I was wondering if there was a way to get the calculation to work
automatically or some other way of refreshing the screen without coming out
of the form? Maybe a button set up with a macro with run the calculation.

Any ideas?

Thanks in advance for help!
Click to expand...

What are the control sources of the other two textboxes? Are they bound to
table fields or unbound (blank control source), or are they also calculated?

This SHOULD recalculate as soon as you type something in either textbox *and
leave that textbox* - if you just type and leave the cursor there, Access
won't realize that you're done.
 
Back
Top