I was trying to use the WhereClause property of the mmPicker control and it didn't seem to have any effect. I checked the code and it didnt' look like it was being referenced anywhere except for the property. In case anyone is ineterested, here's my attempt at implementing it.


public override void PerformSearch()
{
string OrigDataCommand = this.DataCommand;

if (!string.IsNullOrEmpty(this.WhereClause))
{
if (this.DataCommand.ToUpper().Contains("WHERE"))
{
this.DataCommand += " AND (" + this.WhereClause + ") ";
}
else
{
this.DataCommand += " WHERE " + this.WhereClause;
}
}
base.PerformSearch();

this.DataCommand = OrigDataCommand;
}

Jeff