multiple search using adodc and displaying in datagrid

[mukeshsrivastav]

dear sir,

i m design a contact mgmt interface in vb using access . i want to have multiple search option ,suppose i have four field ,first name ,lastname ,city ,state.
the client can enter this his crietria in any of the above field ,and i want search all records which satisfied the creitria
example
user enter
firstname---mc
lastname---john
city---new jersy
state-new york
and click --------search

then datagrid must show all records meeting the crietria.

can you help me.

[aaryan]

dear sir,

i m design a contact mgmt interface in vb using access . i want to have multiple search option ,suppose i have four field ,first name ,lastname ,city ,state.
the client can enter this his crietria in any of the above field ,and i want search all records which satisfied the creitria
example
user enter
firstname---mc
lastname---john
city---new jersy
state-new york
and click --------search

then datagrid must show all records meeting the crietria.

can you help me.

hi mukesh,
think these sort of queries have already occured and been resolved here. anyway, here is one example which will help you.

"select * from customers where customerID = '" & Text1.Text & "' and city = '" & Text2.Text & "' and country = '" & Text3.Text & "'"

i have a doubt too. is it any of the criteria fields or all of the criteria fields should be entered by the user???

[mukeshsrivastav]

hi mukesh,
think these sort of queries have already occured and been resolved here. anyway, here is one example which will help you.

"select * from customers where customerID = '" & Text1.Text & "' and city = '" & Text2.Text & "' and country = '" & Text3.Text & "'"

i have a doubt too. is it any of the criteria fields or all of the criteria fields should be entered by the user???

thanks
but sir writting query is not my problem.major problem i m finding is who to display quered data in datagrid.give me the syntex.datagrid is not allowing me show data searched through the query.it show data in single field filtered mode.
code which i m using is
adodc1.recordset.filter="firstname like ' "& text1.text & "%'".
but system does not take this
adodc1.recordset.filter="firstname like ' "& text1.text & "%'and lastname like' " & text2.text &"%'";

my query returns more then one record.

have u seen www.monster.com,how they allow advance search.like thar i want to do.