G
Guest
How do I get Access to return the text selection from a combo box to the
linked table, instead of returning the selection # of the combo box?
linked table, instead of returning the selection # of the combo box?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
It depend on the location of the text field in the combo
You can use this
Me.ComboName 'return the first field in the source of the combo
Or
Me.ComboName.column(0)
' To rturn the second field use
Me.ComboName.column(1)
You can select any value starting from column(0) which is the first field.
You can use this
Me.ComboName 'return the first field in the source of the combo
Or
Me.ComboName.column(0)
' To rturn the second field use
Me.ComboName.column(1)
You can select any value starting from column(0) which is the first field.