Make textbox display dependent on listbox input

[fulltime]

Hi All,

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

[rnd me]

how are you storing all of the available characters?

[fulltime]

the available chars are all stored in the table.. i m trying to write a query, n assign the result of the query to the texbox but to no avail..

[rnd me]

not sure what you mean by table...
but using an array of chars named arrChars()

' in list1_click
txtChar=arrChars(list1.listindex)

[fulltime]

not sure what you mean by table...
but using an array of chars named arrChars()

' in list1_click
txtChar=arrChars(list1.listindex)

sorry for the confusion, i am using VBA in fact... tat is i have a table to store the 2 fields, language n character...

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

[Hack]

sorry for the confusion, i am using VBA in fact

Moved to Office Development.

[Al42]

You have 1 character per language? The table has 2 fields, Language and Character?

"Select Character From <your tablename> Where Language = '" & listbox.text & "'"

After you execute the select statement, the character you want is in the recordset.

[fulltime]

You have 1 character per language? The table has 2 fields, Language and Character?

"Select Character From <your tablename> Where Language = '" & listbox.text & "'"

After you execute the select statement, the character you want is in the recordset.

ok thks