Limit on List Box?

[rmcompute]

I set up 2 list boxes. When the user clicks the create button, the left list
box is populated with all the available model #s. After the left box is
populated, the user clicks on as many model #s, as required in the left box.
He then clicks the copy button and the model # is cut from the left box and
copied to the right box. The right box values are used to create a report
filter.

The problem is, when the left box is populated, it cannot load more than
1000-1500 models. Is there a limit to a listbox and is there any way
arround it? If there is not, is there any other way to allow a user to make
a multiple selection, without using a range of values?

 

[Marshall Barton]

I set up 2 list boxes. When the user clicks the create button, the left list
box is populated with all the available model #s. After the left box is
populated, the user clicks on as many model #s, as required in the left box.
He then clicks the copy button and the model # is cut from the left box and
copied to the right box. The right box values are used to create a report
filter.

The problem is, when the left box is populated, it cannot load more than
1000-1500 models. Is there a limit to a listbox and is there any way
arround it?

It sounds like you are using a Value List for the model #s.
If you put the model #s in a table, then you should be able
to have up to 32,000. Of course there is also the issue
that any list with more than a few hundred items can be very
difficult to use.

 

[rmcompute]

That did it. I switched to a dropdown list which used a query connected to a
table. The only trouble is that with a value list, I could have the items
move from the left list to the right list. With the dropdown, they will have
to remain in the left list while moving to the right list.

Thanks for the help.

 

[Stuart McCall]

That did it. I switched to a dropdown list which used a query connected
to a
table. The only trouble is that with a value list, I could have the items
move from the left list to the right list. With the dropdown, they will
have
to remain in the left list while moving to the right list.

<SNIP>

You could give this a try:

http://www.smccall.demon.co.uk/Downloads.htm#TwinList

which will handle large lists. It's an importable form, intended to be used
as a subform.