Suing Unbound colums in calculations in Form.

[gucci]

In my form I have a combo box that gets in values from a table.
3 columns 1st bound
column withs 0cm;5.083cm;0cm

But I want to use the 3 colum in a caluation in a text box on the same form.

How do I do this.

Thanks

 

[boblarson]

Me.YourTextBoxNameHere = Me.YourComboBoxNameHere + Me.YourComboboxNameHere.Column(1) + Me.YourComboBoxNameHere.Column(2)

 

[gucci]

If I have a text box on the form that's value is equal to =[OtherTextBox]* column 3 of a combo box wher colum 3 is Unbound it should read...

Me.YourTextBoxNameHere = [OtherTextBox] * Me.YourComboBoxNameHere.Column(2)

Am I right

Thanks, for your help.

 

[boblarson]

The control source of the text box can be set to:

=[Forms]![YourFormNameHere].[YourOtherTextBoxNameHere]*[Forms]![YourFormNameHere].[YourComboBoxNameHere].Column(2)

 

[gucci]

Sorry mate, I'm greatful for your help but I'm not sure what your asking me to do with this info. Could you elaborate onit a little.

Where does this go, Me.YourTextBoxNameHere = Me.YourComboBoxNameHere + Me.YourComboboxNameHere.Column(1) + Me.YourComboBoxNameHere.Column(2)

And if I add =[Forms]![YourFormNameHere].[YourComboBoxNameHere].Column(2) to control source [] are added to Column
=[Forms]![YourFormNameHere].[YourComboBoxNameHere].[Column](2)

Thanks

 

[boblarson]

The Textbox has a property called CONTROLSOURCE. Put the formula I wrote in there.