From data not showing up in table

  • Thread starter Thread starter Jody
  • Start date Start date
J

Jody

I have several calculated controls on a form. The below
example is typical of the type of calculation and
resulting behavior issue I am having.

Example:
Form / Table Field: ContractAmt
Control Source: =[ContractLength]*[MonthlyRate]

Behavior:
The correct amount shows up in the form field but not in
the corresponding field in the table.

What is wrong here? I would expect to see the form data
in the table as well.

Any help will be appreciated.
Jody
 
Jody said:
I have several calculated controls on a form. The below
example is typical of the type of calculation and
resulting behavior issue I am having.

Example:
Form / Table Field: ContractAmt
Control Source: =[ContractLength]*[MonthlyRate]

Behavior:
The correct amount shows up in the form field but not in
the corresponding field in the table.

What is wrong here? I would expect to see the form data
in the table as well.
Click to expand...

Um, no. You don't store calculated values in a table. The control source
tells you the right thing: this piece of information can be uniquely,
reliably and easily be derived from other information stored in the record.

If you need this value in a query, repeat the calculation. (Sorry, there
is no mechanism to store the calculation as a formula.)
 
I assume that you have called the control ContractAmt as
that is the name of a column within the table. However,
Access cannot make that assumption, it needs to be given
that information from the ControlSource property.

If ContractLength and MonthlyRate are also columns on the
table, then there is no real need to have ContractAmt as a
column. You can always calculate it as you have done on
the form.

Hope That Helps
Gerald Stanley MCSD
 
Back
Top