I have a database with two tables. I need to update one with and agency name. The other holds the agency names and ID numbers. How do I search the second table by ID number and to update the agency field in the first table? I tried this

strCriteria = "SELECT Agency_Name FROM Identification WHERE ACH_ID = "'" & IDNUM "'" '

But it doesn't work. I know little about SQL I am just trying it out. What am I doing wrong? Also, please be clear about the ' and " because it is hard to see them on the message board.