textbox problem

[inbal]

i have a form that shows me a list of clients.
i wrote a search code that works when i press a button.
is it possible to make the code work automaticly the second i write something in the text box (without needing the button?)

 

[rainman89]

i have a form that shows me a list of clients.
i wrote a search code that works when i press a button.
is it possible to make the code work automaticly the second i write something in the text box (without needing the button?)

You can do it the second you write something in the box, but it would happen everytime you typed something...

So we would want something that is not quite so quick....

have you tried the afterupdate event?

 

[inbal]

i want ti to update evey time i type something
i just cant find the event that doese it.

 

[gemma-the-husky]

use a listbox or combobox instead of the textbox - these have the behaviour you require inbuilt

 

[inbal]

but if i want all clients that start with A i wont be able to do it,
besides, i have humdreds of people. combo wont be so usefull
is it possible to make it update while typing?

 

[rainman89]

so if you type

A

you want to see all A's

then if you type

AM you want to see all AMs?

You would have to use the Like operator...

And I guess a requery in the onchange event might work???

 

[inbal]

this is exactly what i want.
onchange doesnt do it... cant understand why...
i have the requery written, and it works when i press a button...