Update Control Based on Calc of Other Controls

[JoeyB_99]

I am using Access 2007 and struggling with what I think should be a simple action on a Form.

I have set up a form that reads all the records from a table. This is a result of a make table of payroll based transactions for billing purposes. I called this new table a WorkFile. My form is designed to allow the user to make changes to this data on-the-fly.

Anyway, I want my form to allow the user to change the number of hours. The corresponding rate value is locked in and can't be changed.

For example, there is originally 2.0 hours at a rate of $55.00/hour. The WorkFile will show $110.00 in an extension field, which is also displayed in my form.

The user changes the hours field/control to 3.0. I want to see a new value of $165.00 in the Extension field or control on the form, and I want this new value posted to the Extension field in the WorkFile table.

Any input/suggestions would be greatly appreciated.

 

[bob fitz]

The control that shows the result of Hours*Rate should have its Control Source property set to an expression. Something like:
= [NameOfHoursControl]*[NameOfRateControl]

The result of calculations should NOT normally be stored in a table, rather it should be calculated where ever and where ever it is required.

 

[JoeyB_99]

Thanks Mr. fitz, that worked.

I guess you are right about a calculation should not be stored in a table since it could be a dynamic calculation.

Thanks again.