Form Autocalculations

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

Guest

I have a form I have created that is used by multi-users and is set up to
only let the CurrentUser see their records.

Within this form I have a calculation I want to set up - example below:

FY06Qtr1 * Percentage = 06Qtr1

I have created a text box for the Percentage entry - however for some reason
it updates all of the records in my database. Is there a way that I can set
it for updates to current records only??

Thanks Again!!

Debbie
 
Debbie,
What you have is an "unbound" text control. The ControlSource property
for that field is not "bound" to any field in your table. That also means
that whatever is entered in on one record it will display across all
records.
To "bind" the field, create a field in your table called Percentage, add
it to your form query, and to the form, and any value you enter in
Percentage will be saved as such in the table. And all records can have,
and store, their own Percentage value.
FY06Qtr1 Should be a bound value
Percentage Should be a bound value
06Qtr1 should be an unbound calculated control with a Control Source
of...
= FY06Qtr1 * Percentage
 
You should not be attempting to store the calculated value ...
You should simply display the value using an expression when the value is
needed ...

R. Hicks
 
Back
Top