Creating SEARCH Button - Attached DBS

[gatsby]

Hello everyone,

I just need someone to direct me what to do on how to create a search BUTTON to give results on the listbox after a user typing the desired keywords to search.

As of now, the database has "On Change" property that whenever a key is pressed (from time to time; letter per letter) it automatically change. What I want is for the user to finish the word he/she wanted to search then theres a Search BUTTON to press in order to show the results.

Attached is the database...



And also, how to put Reset BUTTON - to reset the search box and ready for the user to type again.

Thanks...

[June7]

One method is with parameterized query. Review http://datapigtechnologies.com/flash...tomfilter.html

[gatsby]

Thank you. I will try to check this out and get back to you about the outcome, maybe tomorrow.

[gatsby]

I got the Refresh (Reset Form) partially working... partially because it will erase what the user type in the search box BUT the number of items didnt return to the original value which is 5021, instead it remains 77 after the search (located at the left bottom ; with red highlight mark)... i want to reset all - aside from leaving the search box into empty (which is working already) and the number of items will reset also that it will return to its original value which is 5021.

i placed this code in the reset button:

Private Sub Command59_Click()
Me.SearchFor.Value = ""
Me.Requery

End Sub

i know something is missing but i cant figure out what.

any help is highly appreciated.... Thanks!

By the way, I still dont have an idea right now how to create Search BUTTON in my database. the link/video you shared is about combobox which is kinda different with my database. though i got an idea about the reset function...

[gatsby]

ops, nevermind, i got the reset function working - all of it... I placed these codes:

Private Sub Command59_Click()
Me.SearchFor.Value = ""
Me.SrchText.Value = ""
Me.SearchResults.Requery

Me.SearchResults = Me.SearchResults.ItemData(1)
Me.SearchFor.SetFocus

End Sub



my problem now is the Search BUTTON.
any help is highly appreciated....
Thanks!

[June7]

Doesn't matter if the input control is a combobox, listbox, or textbox, the technique works with any.

Since you have only the one input control, don't really need a 'Search' button. The Requery can be in the textbox AfterUpdate event.

[gatsby]

okay, will conduct several tests with this one, because i am not really good in vba but being resourceful can do wonders.... will post the outcome asap.

[gatsby]

okay i GOT IT at last.... i just transfered the codes from OnClick to AfterUpdate and it works... wow!

Thanks a lot June7...