combo box bound column

[Guest]

Hi
i have a simple form comes from a table which describe some travelling
elements...
travelling id---date---course---distance...
the --course--(combobox) "row source" comes from a query with predifined
routes and distances with "column count=2" and "bound column
=1"...(---course---distace---)query.
i would like to ask if its possible every time i select a value from the
--course-- combo, (athens-vienna for example) , i could take the
corresponding value in the --distance-- automaticaly ...
Thanks

 

[fredg]

Hi
i have a simple form comes from a table which describe some travelling
elements...
travelling id---date---course---distance...
the --course--(combobox) "row source" comes from a query with predifined
routes and distances with "column count=2" and "bound column
=1"...(---course---distace---)query.
i would like to ask if its possible every time i select a value from the
--course-- combo, (athens-vienna for example) , i could take the
corresponding value in the --distance-- automaticaly ...
Thanks

Use an Unbound text control on the form.
Set it's control source to:
=ComboName.Column(1)
where 1 is the number of the column.
Since Combo Boxes are zero based, 1 is actually the 2nd column.

Alternatively, leave the unbound text control blank.
Code the Combo Box AfterUpdate event:
Me![TextControlName] = Me![ComboName].Column(1)

 

[Guest]

Thanks!!!

Hi
i have a simple form comes from a table which describe some travelling
elements...
travelling id---date---course---distance...
the --course--(combobox) "row source" comes from a query with predifined
routes and distances with "column count=2" and "bound column
=1"...(---course---distace---)query.
i would like to ask if its possible every time i select a value from the
--course-- combo, (athens-vienna for example) , i could take the
corresponding value in the --distance-- automaticaly ...
Thanks

Use an Unbound text control on the form.
Set it's control source to:
=ComboName.Column(1)
where 1 is the number of the column.
Since Combo Boxes are zero based, 1 is actually the 2nd column.

Alternatively, leave the unbound text control blank.
Code the Combo Box AfterUpdate event:
Me![TextControlName] = Me![ComboName].Column(1)