A Calculated field on a form

Gerryw

Registered User.
Local time
Today, 10:04
Joined
Jun 20, 2003
Messages
13
I would like to know how to get the sum total of 2 fields on a form to show in a third field i.e. [NumHrs]*[PayRate]. I have tried quite afew ways to do this but i am getting nowhere and i am frustrated (the fields are combo boxes)

Gerry
 
Try setting the control source of the third control to be:

=[NumHrs]*[PayRate]

Hope this helps,
 
Questions

1) Is the third field a combo box too?
2) Is the third field bound?
3) Do all the combo boxes have a single column?
4) If not, is the value displayed in each the bound value?
5) Is the form a continuous form?
 
Let's try this another way.

What happens when you enter

=[NumHrs]*[PayRate]

in the third Field?

If it is a combo box, can you send me some samples of the data in the combo box.
 
Make sure that your controls are NOT named the same as your fields. That'll mess things up straight away.
 
A calculated Field on a Form

Hi Boblarson,
Thanks for you help. I'll check that out.

Gerry
 
You could also try putting this code on the After Update event of the Pay Rate combo.

Me.txt3rdField = Me.cboNumHrs * Me.cboPayRate

It works for textfields, so it 'might' work for combos

Dave
 

Users who are viewing this thread

Back
Top Bottom