Urgent! - Sourcing in a form

S

Steve A

Hi,
I have a form where I source a value from a table column

=(Service.Column(1))*1.61

This reads the value fine.

However I have now added another field to this Service table and I want
another text box to tell me the value of this. Eg

=(Service.Column(2))*1.61

When I try this it doesn't show anything, even though there is data in this
field. i have tried changing the column number to every possible one,
although I don't see why it wouldn't be 2 as it is the next filed after
column 1.

When I change the value to column 1 it will show again. But not on any
other column.

Is it possible to do this on the form twice.
Any ideas why this isn't working?

Thanks

Steve A
 
J

John Vinson

Any ideas why this isn't working?
Click to expand...

Most likely the column count on the combo box is 2. Change it to 3 so
that all three fields in the query are included in the combo.

John W. Vinson[MVP]
 
S

Steve A

Exactly right, thanks very much!

John Vinson said:
Most likely the column count on the combo box is 2. Change it to 3 so
that all three fields in the query are included in the combo.

John W. Vinson[MVP]
Click to expand...
 
Top