use text box to control combo box content

[kobekaren]

i have a question

i want to use a text box to controp the content of the combo box.
for example

table [key]
id key
1 xxx1
1 xxx2
1 xxx3
2 yyy1
2 yyy2

there is a text box called "id" and combo box "key" on a form
when i fill the [id] text box , ie "1", then the combo box will only show "xxx1,xxx2,xxx3" !!

i build an event (after update event) on the text box and
i don't know how to set the row source of combo box.

can anyone help?
thank you very much !

 

[namliam]

Combobox.rowsource = "Select ... from ... where ... = " & textbox.value
combobox.requery

 

[kobekaren]

thank you very much !!
it WORKS !!

thanksssssssssss !!!!!!!