Member Avatar for BORIS_4

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

  • 2 Contributors
  • 2 Replies
  • 48 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by BORIS_4
Member Avatar for Reverend Jim

Try using "&" instead of "+".

Adodc1.Recordset.Filter = "br_name LIKE '" & t & "'" _
                          "  OR mo LIKE '" & z & "'"
Edited by Reverend Jim
Member Avatar for BORIS_4

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.