Solved Confusing Combo-Box requirement...

[prabha_friend]

it's a Multi-column ComboBox having the following Data as Columns:

217	Dhathri Herbal Oil	தாந்தரி ஹெர்பல் ஆயில்
218	DND	டிஎன்டி
219	Domex Fresh Guard Lime Fresh	டோமேக்ஸ்

When the User starts Typing the English value we need to show the Tamil value
User Types: Dha
ComboBox Suggests: தாந்தரி ஹெர்பல் ஆயில்

Possible?

 

[cheekybuddha]

Possible?

Not really.

You would have to concatenate the values (use 2 columns instead of 3).

ControlSource would be:
SELECT ID, [EnglishField] & " - " & [TamilField] FROM YourTable
instead of:
SELECT ID, [EnglishField], [TamilField] FROM YourTable

But I don't know whether there would be a problem displaying both English and Tamil together from a font perspective.

 

[isladogs]

It should be possible to output the content of column(2) - the Tamil version - to a textbox.
However, you may have to wait until typing has completed.
Try something like this, substituting the name of your combo and the textbox

Private Sub ComboName_AfterUpdate()
   Me.TextboxName= Me.ComboName.Column(2)
End Sub

If that works, then you can adapt find as you type code to do something similar in the OnChange event

 

[MarkK]

Here's a simple example of one way to do this...

 

[Uncle Gizmo]

It should be possible to output the content of column(2) - the Tamil version - to a textbox.

Further to Colin's suggestion:-

Display Data from a Combo Box in a Text Box - Nifty Access

Display Data from a Combo Box Combo boxes are one of the most valuable controls you can have on a form, they are so versatile and give you such an extra range of functions for your form that you should really consider understanding how to use them. Also with a combobox as your foundation, you

www.niftyaccess.com

See YouTube at time index 2:50