How to get value from combo box?

[101287]

I have a field defined in a form that is a combo box. The combo box has three fields. The combo box is bound to field 1. However, I would like to do some processing base on the other fields (fields 2 and fields 3). Is there anyway that I can retrieve those fields (values from field 2 and field3) within access when the combo box is selected.

Your guidance is really appreciated.

Luis

 

[TheAceMan1]

How are ya 101287 . . .

Use the [blue]column index[/blue] of the control. Example:

[blue]   Me!TextboxName = ComboboxName.Column(column,row)[/blue]

Note: column/row indices start at zero.

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[101287]

Thank you but how do I know the row selected in the combo box. If I can determine the row selected in the combox box then I should be able to use your suggestion.

Please advise.

Luis

 

[PHV]

Me![ComboboxName].Column(1) ' Field2

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[TheAceMan1]

101287 . . .

You don't have to use the row as shown by [blue]PHV[/blue].

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]