Form 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
 
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
Click to expand...
Access is working correctly.
The calculated control is not bound to any field, nor should it be.
As long as your table has the [Monthly Rate] and the [Contract Length]
fields, all you need do whenever you need the ContractAmt is to repeat
the calculation, in a form, in a query, or in a report.
That is the 'proper' way to use Access.
 
That is good to know - Thanks Fred!
-----Original Message-----
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
Click to expand...
Access is working correctly.
The calculated control is not bound to any field, nor should it be.
As long as your table has the [Monthly Rate] and the [Contract Length]
fields, all you need do whenever you need the ContractAmt is to repeat
the calculation, in a form, in a query, or in a report.
That is the 'proper' way to use Access.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Fred -

On second thought;

Now I would like to use the calculated values on a
report. Since they are not in the table I am having
difficulty in figuring out how to do this.

I have tried a variety of options in a text box control
source, all of which return #Name? either #Error. I am
not al all versed in VB or the expression builder so any
help you can offer would be appreciated.

Jody
-----Original Message-----
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
Click to expand...
Access is working correctly.
The calculated control is not bound to any field, nor should it be.
As long as your table has the [Monthly Rate] and the [Contract Length]
fields, all you need do whenever you need the ContractAmt is to repeat
the calculation, in a form, in a query, or in a report.
That is the 'proper' way to use Access.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Fred -

On second thought;

Now I would like to use the calculated values on a
report. Since they are not in the table I am having
difficulty in figuring out how to do this.

I have tried a variety of options in a text box control
source, all of which return #Name? either #Error. I am
not al all versed in VB or the expression builder so any
help you can offer would be appreciated.

Jody
** snipped **
Click to expand...
You must repeat the calculation in the report, using the same fields
used in the form calculation.
Make sure the [ContractLength] and the [MonthlyRate]
fields are included in the Report's Recordsource.
Then using an unbound control, set it's record source to:
=[ContractLength] * [ContractAmt]

** Make sure the NAME of this control in neither "ContractLength" nor
"ContractAmt". **

There is no VB needed. You have already used this expression in the
form.
 
Back
Top