i want to make a report where i can filter a record by date and by county
but i cant do it at the same time well i can filter it by county itself or by date itself here's my code:

for county:
DataEnvironment1.rsCommand1.Filter = "County ='" & Combo1.Text & "'"

for date
DataEnvironment1.rsCommand1.Filter = "DP = '" & Text1.Text & "'"

for both but causes a TYPE MISMATCH ERROR
DataEnvironment1.rsCommand1.Filter = "DP = '" & Text1.Text & "'" And "County ='" & Combo1.Text & "'"

Can you help me?