I am working on updating and improving an old database and changing the table structure, etc. The data imported well into the new table, but now I want to add the proper "relations" back to the data. I'm trying to lookup text found in one table in a second table (better said a recordset?) that is also a text field. I'm getting a data type mismatch error.
Dim Customers_rst As DAO.Recordset
Dim ZIP_rst As DAO.Recordset
Set Customers_rst = CurrentDb.OpenRecordset("Customers", dbOpenDynaset)
Set ZIP_rst = CurrentDb.OpenRecordset("tblZIPCodes")
Let strZipToActOn = ZIP_rst.Fields!ZIP
strSearchData = strZipToActOn
Customers_rst.FindFirst "CustPostalCode = " & strSearchData
Is there an obvious problem here?
How many points should be assigned to a question like this?