I have a single category PickListCollection that works just fine.
The view used by PickListCollection is categorized as it should be, the second column is sorted.
When I display the PickListCollection I would excpect to be able to use the “Starts With” dialog box to quicky go to one on the sorted items in the first (really second but the categorized column is hidden). But it does not work.
What is really disturbing is that view will try to change to one of the categorized items but if it was not used in the Single Category parameter of the PickListCollection function then the view goes blank.
Example say we have a categorized view where the columns look like this:
AAA 123
AAA 456
BBB 789
BBB 111
And the PickListCollection is called:
Set collection = ws.PickListCollection(3,False,db.Server ,db.FilePath ,"vwDefsByMenu",v & "- Menu","Select the desired Form and click OK","AAA")
All the AAA documents will be displayed in the view. One would expect typeing 456 would take you to the AAA 456 document. This does not work typing AAA finds something and typing BBB finds something but the view goes blank!
It seems that “Starts with” is searching on the categorized column and not the second sorted column.
Am I missing something???