I am having a problem with the mmPicker control while using a stored procedure as the DataCommandType. If I use a text statement to retrieve the data:
SELECT Symbol, Name, CompanyID FROM Company
and set the DataCommandType to Text, I have no problem.
If I use a stored procedure and set the DataCommandType to StoredProcedure, mmPicker works fine but it won't filter the results. For example, if I type in an 'I' and hit enter, the list is not filtered to show just the companies that start with I. It works fine if I use DataCommandType = Text.
Chris McCandless
Red Sky Software