A Calculated field on a form

[Gerryw]

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

 

[Peter D]

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

=[NumHrs]*[PayRate]

Hope this helps,

 

[jaydwest]

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?

 

[jaydwest]

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.

 

[boblarson]

Make sure that your controls are NOT named the same as your fields. That'll mess things up straight away.

 

[Gerryw]

A calculated Field on a Form

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

Gerry

 

[daveUK]

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