[RESOLVED] Listbox n TextBox

Hi,

I have 2 fields, Language and Character in my table. Now i am designing a form for it. I am using a list box for all the language n a textbox for the character.

Wat i wan to achieve is as follows :

Whenever the user clicks on any of the language in the list box, its corresponding character will be displayed in the textbox. How can i achieve it? thks :)

FT

using VB or VBA(Access)???

if it is vba then the simple way for it is bound the list box to both the columns(you can display only one column) and then under the listbox_onclick event

simply write the fallowing line.

VB Code:

text1.text=list1.coumn(1,list1.ListIndex)

all the best..

ok thks :)