reference to lookup value

[Guest]

I'm trying to write an expression that refers to a value in a combobox on a
form that is derived from a lookup field on a table that (of course) refers
to values on another table. How can I properly reference this? Messing
around with the bound column properties for the combo box and the underlying
table has not helped. The only values I can get passed through to the VBA
editor are the index value and null.

 

[Guest]

If the RowSource of the combo include few fields

Select Field1 , Field2 , Field3 From TableName

To get the value from the combo
Field1:
Forms![FormName]![ComboName].Column(0)

Field2:
Forms![FormName]![ComboName].Column(1)

Field3:
Forms![FormName]![ComboName].Column(2)

Note: The column number start with 0,
If the column count on the combo property is less then 3, then the third
column in the combo wont be recognize

 

[Guest]

Sorry. I forgot to let you know that this was a big help!
--
Why are you asking me? I dont know what Im doing!

Jaybird

If the RowSource of the combo include few fields

Select Field1 , Field2 , Field3 From TableName

To get the value from the combo
Field1:
Forms![FormName]![ComboName].Column(0)

Field2:
Forms![FormName]![ComboName].Column(1)

Field3:
Forms![FormName]![ComboName].Column(2)

Note: The column number start with 0,
If the column count on the combo property is less then 3, then the third
column in the combo wont be recognize

--
Good Luck
BS"D

I'm trying to write an expression that refers to a value in a combobox on a
form that is derived from a lookup field on a table that (of course) refers
to values on another table. How can I properly reference this? Messing
around with the bound column properties for the combo box and the underlying
table has not helped. The only values I can get passed through to the VBA
editor are the index value and null.

 

[i_takeuti]

Sorry. I forgot to let you know that this was a big help!
--
Why are you asking me? I dont know what Im doing!

Jaybird

If the RowSource of the combo include few fields

Select Field1 , Field2 , Field3 From TableName

To get the value from the combo
Field1:
Forms![FormName]![ComboName].Column(0)

Field2:
Forms![FormName]![ComboName].Column(1)

Field3:
Forms![FormName]![ComboName].Column(2)

Note: The column number start with 0,
If the column count on the combo property is less then 3, then the third
column in the combo wont be recognize

--
Good Luck
BS"D

I'm trying to write an expression that refers to a value in a combobox
on a
form that is derived from a lookup field on a table that (of course)
refers
to values on another table. How can I properly reference this?
Messing
around with the bound column properties for the combo box and the
underlying
table has not helped. The only values I can get passed through to the
VBA
editor are the index value and null.