How To Combine 2 Query

I have 2 tools inside my form ADODC and Datagrid. the recordsource for adodc is

select * from directory where firstname <> 'spare'.
the problem is i have another text for searching purposes and its gonna rewrite the recordsource like this

select * from directory where firstname like '%' & replace(txtName.text), "'", " ' '"

- this will show the results inside the datagrid as it follows and join the recordsource of adodc components.


How to combine both of the query inside one procedure. where its gonna search what he/she want in the textbox and at the same time it filters which records contain 'spare' in firstname field.

NEED URGENT HELP..Thank you

Try this