t = txtSearchMo.Text
z = Combo1.Text
Adodc1.Recordset.Filter = "br_name like '" + t + "'" Or "mo like '" + z + "'"

why this code have mismatch error appear?? help me pls

Recommended Answers

Try using "&" instead of "+".

Adodc1.Recordset.Filter = "br_name LIKE '" & t & "'" _
                          "  OR mo LIKE '" & z & "'"
Jump to Post

All 2 Replies

Try using "&" instead of "+".

Adodc1.Recordset.Filter = "br_name LIKE '" & t & "'" _
                          "  OR mo LIKE '" & z & "'"

not working sir..

arguments are wrong type, are out of acceptable range, or are in conflict with one another

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.