I need to essentially run a SELECT query for a recordset. I have a value that I am passing to a function from rs1. rs2 is where I am updating the data. I need to filter rs2 to equal the value passed from rs1. I thought the below code would do it but it obviously didn't work. Thanks in advance.
Code:rs.FindFirst "[EmplID] = " & emplID