Solved Searchable List Box on Form (1 Viewer)

[Hecronis]

I have a list box that I would like to make searchable. What I would like to have is when nothing is in the "Search Box" the list box shows all entries but when the "Search Box" has something in it and the person presses the Search Button it brings up the results in the list box.

I only know how to make it do one or the other. Either show all results and not be able to search or search and it not show any results when the search box is blank.

 

[theDBguy]

Hi. Perhaps you could use an If/Then block. You know, like.

If SearchBox is empty Then
    'show all
Else
    'show search result
End If

 

[arnelgp]

maybe some sample will help you.
see the code-behind the textbox.

 

[Hecronis]

maybe some sample will help you.
see the code-behind the textbox.

That worked perfect! I had to do a little modifying to match up with my db but it is good to go. Thank you.

 

[LanaR]

I know I'm late to the discussion, but search in sample Database section of the forum for "Dynamically search multiple fields" and have a look at that DB, it's a really handy example

 

[Uncle Gizmo]

sample Database section of the forum for "Dynamically search multiple fields"

Do you mean this one?

Dynamically search multiple fields

This DB is a modification of a search tool that was posted in these forums several years ago. The tool allows the user to type text into a text box (the text is matched against any part of a number of fields) with the results being shown dynamically in a list box as the user types. Essentially...

www.access-programmers.co.uk

 

[LanaR]

That's the one I got an error when I tried to post a link to it

 

[Uncle Gizmo]

That's the one I got an error when I tried to post a link to it

I believe the forum software stops you making posts until you've built at the reasonable level of responses. This helps reduce spam and work for the moderators...