Your thoughts on List Box

[Blkblts]

I have a reporting database which contains information on the number of times a member has placed a call. I want to report various information about this call. On a form I have a list box that can choose multiple members. (I have 100,000 members but only around 70,000 show up in list box. I figure there must be a limit). My problem is I don't want a user to have to search through umpteen thousand names in the list box. Does anyone have a suggestion as to how I should modify the form in order for the user to more efficiently choose multiple members?

Thanks in advance for your suggestions.

kim

 

[Richie]

How about grouping them by location?

 

[Blkblts]

Location is a good suggestion, but we do not document the call based upon location. I'll tell ya I tried date because I could type that in a text box and then when the user tabed out (lost focus) I then ran a query to the listbox to only show members that placed a call during those dates. My drawback there was I got duplicate names. Such as it showed up 5 times if the member placed a call on five different dates.

Thanks

 

[Richie]

Group by name then?

 

[Blkblts]

Thanks

Here was my query before
Select * from folder
where ag_date between blah and blah;


Here is my revised query that works magik plus I am able to go back to using my lost focus from previous

Select Fld, Fld_Desc
Where ag_date between blah and blah
Group by Fld, Fld_Desc;

Many thanks for your help...

kim