Make a List box searchable

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello:
Does anyone know if there is a way to make a list box searchable. For
example, I have a list box that has several columns. Some columns contain
numbers (text) and some names. Is there a way to create a search procedure
similar to the one that Access' built in search procedure to search the list
box for a particular value. (The Access built in Find next does not work).
Thanks,
Jade5
 
Hello:
Does anyone know if there is a way to make a list box searchable. For
example, I have a list box that has several columns. Some columns contain
numbers (text) and some names. Is there a way to create a search procedure
similar to the one that Access' built in search procedure to search the list
box for a particular value. (The Access built in Find next does not work).
Thanks,
Jade5
Click to expand...

A Listbox isn't intended as a data storage or search medium. Instead,
it's designed to let you choose one visible value and use THAT to find
something else, or to update a table.

I suggest that a listbox is simply the wrong tool for what you're
trying to accomplish, and that a Subform based on the same query as
you're now using as the RowSource of the listbox would be much better.
That will look quite similar (or can be made to look similar if you
wish); and the search tool will work nicely.

John W. Vinson[MVP]
 
Thanks John.
If I create the subform will I be able to click on a name and open a form
with the record displayed?. For example, I have a list of companies. If I
click on a company name in the subform (that replaces the listbox) can I
still open another form that shows the record for the name I clicked on?
Also, I am assuming that this subform will be Datasheet view to resemble a
list box.
 
Thanks John.
If I create the subform will I be able to click on a name and open a form
with the record displayed?. For example, I have a list of companies. If I
click on a company name in the subform (that replaces the listbox) can I
still open another form that shows the record for the name I clicked on?
Also, I am assuming that this subform will be Datasheet view to resemble a
list box.
Click to expand...

You can use Continuous Form view (and make it look very like a listbox
if you wish), and put a Command Button on each record to do so.

John W. Vinson[MVP]
 
Back
Top