The problem with calculated text boxes

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
 
V

Van T. Dinh

Try using Calculated Field in the Query used as the RecordSource for the
Subform.
 
G

Guest

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
 
V

Van T. Dinh

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.
 
G

Guest

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
 
J

John Vinson

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.
 
G

Guest

Hi John,

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

Kenny
 
G

Guest

Hi John,

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

Kenny
 
Top