Unbound text box calculation

[dab1477]

Thanks in advance for the assist. My mind went numb...

What must I do to have an unbound field only perform the calculation for the
current open record that I am working in and not show data in a new records
same unbound field when I go to the next record entry?

I have an unbound text box on a form - call it Box C. In it's properties
control source I have a calculation (i.e. =text box A input / text box B
input) that I wish to show within the form prior to moving to the next
record. I then wish this field to recalculate or return null (if box A and/or
B are empty). Box C will calculate correctly, but when I move to the next
record to input data, Box C maintains the previous record's data - but only
within Box C. All other fields are blank and ready to accept new data.
Box C calculates within the new record based upon the prior records data in
Box A and Box B; even when I have not entered any data into the new record.
Please point me in the right direction. Thanks

 

[Tom van Stiphout]

On Wed, 2 Jun 2010 06:17:01 -0700, dab1477

That is not the way an unbound textbox normally behaves. So I have
these questions:
* What is in the ControlSource of this box3?
* What if any VBA code is in this form that may be related?
* Any macros operating on this box3?

-Tom.
Microsoft Access MVP

 

[KARL DEWEY]

You need to refresh Box C on change of one of your bound fields.

 

[KARL DEWEY]

I made the assumption that Box A and Box B were bound to fields in your table.

 

[dab1477]

Karl,
You are correct that Box A & B are bound. Would Box C not be refreshed when
I go to the next record? Remember "Box C will calculate correctly, but when I
move to the next record to input data, Box C maintains the previous record's
data - but only within Box C. " I'm in the next record with blank fields but
Box C has the calculation of the prior fields.
I resolved the issue by binding Box C to the table. Now that it is BOUND,
all seems in order. As it was a calculation, I was hesitant to bind to my
table, but I found some usefulness in doing so. Thanks for the input.

 

[dab1477]

Tom,
To answer you questons:
* What is in the ControlSource of this box3?
....as noted in my original post the ControlSource was formula"=text box A
input / text box B input".
* What if any VBA code is in this form that may be related?
....there was code. I omitted the formula from the control source and all
seems to be working now. Thanks.
* Any macros operating on this box3?
.....no macros in box C.
I resolved the issue by binding Box C to my table. Although a calculation
and this would not require binding, I found that it may be useful. Binding
the text box to the table resolved my issues. Thanks.

 

[Tom van Stiphout]

* What is in the ControlSource of this box3?
...as noted in my original post the ControlSource was formula"=text box A
input / text box B input".

The reason I asked is that there often is a syntax error in an
expression that we can spot if we get the real expression rather than
your stylized version.
Glad you got it to work.

-Tom.
Microsoft Access MVP