Hi All

i need to use this query to find person,each person has a 3 fields as unique : mem_id,c_id,r_id
mem_id and c_id are as numerical and r_id is string

i use the query but is not works accurate and show another records .

Code:
rs.Open "SELECT * FROM Reg where mem_id=" & Val(txtfind.Text) & " or c_id=" & Val(txtfind.Text) & " or r_id='" & Trim(txtfind.Text) & "' ", db, adOpenKeyset, adLockOptimistic
what's wrong this query!?

how can i use query so that i can run query with this 3 fields as simultaneously with accurate result ?

thanks all