Joe,

>I have a mmPicker on my WinForm configured as follows:
>VisitorSelectionPicker
>DataCommand: Select * From Visitors Order By VisitorLastName, VisitorFirstName, CompanyName
>GridColumns:
> 1. VisitorLastNameColumn (BindingSourceMember = VisitorLastName) 2. VisitorFirstNameColumn (BindingSourceMember = VisitorFirstName)
> 3. VisitorCompanyNameColumn (BindingSourceMember = CompanyName)
>GridDefaultSortColumn: VisitorLastNameColumn
>PickListDisplayMember: VisitorLastName
>PicListSearchField: VisitorLastName
>PickListValueMember: VisitorId

It looks like the problem is in your DataCommand setting--if you drop the Order By clause it should work. The picker automatically adds a WHERE clause to the end of your DataCommand (when it's not a sproc) to narrow the result set based on what the user has typed in.

Regards,