I wonder if somebody could help me out here as i am getting confused. i want to search my access DB based on surname and forename. It works great if i search on surname but I just get muddled up when trying to combine both the surname and the forename fields.
Below is the code i use to search by surname:
Set rs1 = db.OpenRecordset("SELECT * FROM query1 " & "WHERE surname = " & "'" & txtsurname.Text & "'", dbOpenDynaset)