Make textbox display dependent on listbox input

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

how are you storing all of the available characters?

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.. :(

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

' in list1_click
txtChar=arrChars(list1.listindex)

Quote:

---

Originally Posted by rnd me

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

Quote:

---

Originally Posted by fulltime

sorry for the confusion, i am using VBA in fact

---

Moved to Office Development.

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

VB Code:

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

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

Quote:

---

Originally Posted by Al42

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

VB Code:

"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