form/table

  • Thread starter Thread starter Noguy
  • Start date Start date
N

Noguy

Hello all,

I have a form field that performs a calculation based on
two other fields in the form. How can I get that result
to show up back in the table upon which the form is based?

Noguy
 
Proper database design would dicate that you do not store any calculated
fields in the table. When you need to use that calculated information, you
can perform the calculation in the query, report, or form that you are
using. Storing it in the table would be redundent.

Rick B


Hello all,

I have a form field that performs a calculation based on
two other fields in the form. How can I get that result
to show up back in the table upon which the form is based?

Noguy
 
As was said in the other reply, it's probably not a good idea.
However, access aint the snappiest of DBs, and it may be necessary to
cache some info in this way. In fact, it's standard, nay, required!
to store calculated info for certain schemas.

In any case, what kind of calculation are you attempting? If it is
possibly, you should make a query that does the calculation for you,
and then use that query as the source of the form.

If you do have to save the data this way, you could just bind a
control to the field in the table, and then call a little sub that
does the calculation and sets that textbox's .value and then refreshes
the form to save (me.refresh).

HTH

Hello all,

I have a form field that performs a calculation based on
two other fields in the form. How can I get that result
to show up back in the table upon which the form is based?

Noguy
Click to expand...

..--------------------------------------
| Andrew Backer
| backer_a @ h0tmai1 dot com
`--
 
Back
Top