On Change event in Text Boc

[quicova]

Hello,

I created a continues Form with a query and I have a text box for search
In the query criteria in the column "Part_Name" I have:

Like "*" & [Forms]![Part_List_form]![Search_Box].[Text] & "*"

Then In the form on the text box I created an Event Procedure

Private Sub Search_Box_Change()
    
    Me!Part_Name.Requery
    DoCmd.ShowAllRecords
    
End Sub

The problem is that I can only type 1 letter because it jumps of the text box every time I type something.


If I change the procedure to After update it works, but what I want is that dynamic search style of search.

Can anyone help me out with the code, how do I tell it to not jump of the text box

Thanks so much
Francisco

[June7]

Could use a combobox for the AutoExpand property and use AfterUpdate event.

Or is this what you want http://allenbrowne.com/AppFindAsUType.html

[mrojas]

Why not create a "Search" button that the user clicks once is has input all the required information. Place your code under the OnClick event of button.