Combobox- How to dsiplay more than first field

[FreddieLeaf]

I'm using a combobox to select an item from a dropdown list. Once the item is selected and dropdown list closes, only one the first field shows up in the combobox window.

How can I make more than one field showup?

Thanks.

 

[llkhoutx]

A combobox only displays one field.

Additional fields may show in textboxes.

On the combobox AfterUpdate event execute the following code

me!textbox1 = me!combobox1.column(i)

where "i" is the combobox column number you want to display. Columns are numbered 0 thru n, i.e. 0, 1, 2, 3, . . .

 

[FreddieLeaf]

This is perfect. Thanks.