Forms

  • Thread starter Thread starter Tiff
  • Start date Start date
T

Tiff

I am kind of new to access and I keep running into some small problems. I
have a table that needs to be manually updated. So I created a form to input
the needed info. Inside that form there is a caculation on 2 of the txt
boxes, so the user dosen't have to input that information. My problem is that
when the user puts in all the needed information the table will update
everything that the user put in except for the information that was
automatically caculated. How can I get my table to update that information as
well?

Thanks in advance
 
Don't.

Database normalization rules state you don't store values that can be
calculated. You have all the fields necessary for the calculation in the
record. Rather than store a calculated value, do the calculation, as you are
now, on the form and on a report.
 
Back
Top