display multiple columns in combo and enter specific column intofield

  • Thread starter Thread starter bjwheeler
  • Start date Start date
B

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
 
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
 
Back
Top