display multiple columns in combo and enter specific column intofield

[bjwheeler]

Hi there,

I have a combo box in a form that i have using a query displaying
three columns.

Provider Name;Provider Code;Type

I have got the combo bound to column 1 (Provider Name), so that the
user can type in full name of the provider. However, i want the
Provider Code to be stored against the record. and if possible, have
the Provider name still display in the combo box. If that cant be
done, I don't mind having the provider code showing on the combo after
selection. so long as the user can still type in the provider name.

Dont know if you need this.... this is the query that displays the
combo..

SELECT [Provider Profile].ProviderName, [Provider
Profile].ProviderCode, [Provider Profile].Type FROM [Provider
Profile];

thanks!!

BW

 

[Allan Murphy]

BW
Use the Column property of the Combo box

Assume the ProviderCode is the name of the field to store the provider code
from the combo box. on your form

In the After Update Event of the combo box put the following
Me!Provider Code=(Name of your Combo Box).column(1)

Note although the Provider Code is in the second column of the combo box the
numbering starts at 0 for the first column

Allan