DataAssist Search on Recordset with WHERE filter
How to make DataAssist to work on my Recordset with WHERE status != 'pending'. The search works only when I remove the filter but I really need to filter my pending status and it is important to have search function at the same time. Please I need assistant on this!