Combo Box Shown Values

[Fizzio]

I have a combo box with 3 fields; ID, ShortCode and Name. I have the columns set to 0;1;2.5 so only the ShortCode and Name are shown. What I want is for the user to be able to type in the short code but the combo box to display the name. Can this be done?

 

[John.Woody]

Not sure but you could put a text box next to it and show the name in there.

 

[Fizzio]

Thanks but I forgot to say that the form is in datasheet view.

 

[John.Woody]

The Text box would still work in datasheet view if you have the room for it.

 

[Fizzio]

Cheers, never thought of that. I'll give it a go and feedback.

Thanks Woody, With a bit of tinkering, I added an unbound text box into the form and set it to the column of the dropdown with the info I wanted (Edit)

[This message has been edited by Fizzio (edited 11-20-2001).]