Searching a splitform

[Core]

Hello,

I have a split form (picture attached), I want to create a text box that will filter the information.

I have tried binding the splitform to a query, with criteria based on the value of the text box, then creating a re-query event when a key is pressed in the textbox. This works for about 1 second then it shows all data again.

query criteria:

like "*" & MyControl.text & "*"

Text box event (onKeyUp):

MyForm.Requery

Any idea's what I have done wrong?

 

[ajetrumpet]

the query criteria should be:

WHERE

[field] = forms!formNAME!textbox

also, requerying it after every key press is probably not a good idea, as this could crash access is someone types quickly. I personally can type 80 words a minute, so I could probably get this done.

so, maybe choose a different event...or put a button along side the box.

the other probably with the key press event is the size of the query. if it gets too big, the requeries will not be able to keep up with many peoples' typing.