The problem with calculated text boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi guys,

I have a calculated text box that uses 2 other text boxes to make a
calculation. I have the form set to appear as a continuous form.

The problem that I have is that when I enter the textbox, the calculation is
done as it should be, but then the value of all the textbox of all the
records changes to the result.

Is there any way around this except to actually store the result in the
table?

Thanks guys.

Kenny
 
Hi there,

Ok......I tried it and it now displays the correct result, except now I
can't enter data, as the original record source was my table.

Kenny
 
Do you meant you can't enter data in the Calculated Field or other Fields?

You cannot enter data in Calculated Field and you should not store the
Calculated Value in the Table since this violated the Relational Database
Design Principles.
 
Hi,

Yup, the query won't let me enter data in the other fields.......am I using
the wrong type of query. It is a select query.

Thanks

Kenny
 
Yup, the query won't let me enter data in the other fields.......am I using
the wrong type of query. It is a select query.
Click to expand...

Please open the Query in SQL view and post the SQL text here. Not all
select queries are updateable; someone may see why this one isn't.
 
Hi John,

Thanks......based on what you said, I went and redid the query and now it
works.

Kenny
 
Hi John,

Thanks......based on what you said, I went and redid the query and now it
works.

Kenny
 
Back
Top