By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,027 Members | 1,199 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,027 IT Pros & Developers. It's quick & easy.

Multiple search using List box

P: 16
Hi all,

I have recently created a list box in a form.....I wanted to know if there was a way of searching for multiple records within the list box.

How can i get this list box to search for multiple records and create a report with the searched data listed.

If there is a simple way to do this then i would appreciate the advice

Many thanks.
Dec 12 '07 #1
Share this Question
Share on Google+
5 Replies

Expert Mod 15k+
P: 31,615
You can have a ListBox that handles Multiple selections but searching for them is another matter.
It may be possible to type the first characters in an entry but I don't know how well (or at all) this works after the first entry has been selected (and you're holding the Ctrl key).
Dec 12 '07 #2

P: 16
Is there any way of searching for multiple records then?

Dec 12 '07 #3

Expert Mod 15k+
P: 31,615
There seems to be some misunderstanding.
What do you mean by "Record" in this context?
What do you mean by "Search for"?
Dec 12 '07 #4

P: 16
Hi there,

When I say record I mean in terms of finding or filtering data from a sets of records.

When I say search for I mean filtering.

Basically I have being trying to filter data from my original data list, I have built queries with parameter and search boxes, however this only allow me to search for singular parameters in each field.

Then I tried to use the pivot table option.

Basically I was wondering if there was a way to build a form that would allow me and the users to filter data with ease. E.g. If the form could have a tab like pivot tables, therefore allowing the user to filter information and multiple data sets within the form.
Jan 21 '08 #5

Expert Mod 15k+
P: 31,615
Have a look at Example Filtering on a Form. If it doesn't help you to do what you want then come back and explain where you still have problems. Good luck.
Jan 21 '08 #6

Post your reply

Sign in to post your reply or Sign up for a free account.