Thanks for you help. This is what is going on now...

strCriteria = "SELECT Agency_Name FROM Identification WHERE ACH_ID = " & IDNum
rs.AddNew
rs("Agency")= strCriteria

This is where I get an error telling me the Agency field is not long enough to accept the value of strCriteria. I stepped through the program and when it gets to the rs("Agency") = strCriteria, the value of strCriteria is all words in the "s. What am I doing wrong?