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!
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!