VBA Script to Find/Replace values in column

Hello Experts,

I think there is a straight-forward solution to this, but I am struggling with it.

I have a query (qryConvertProdNum) that returns the following fields

  Product,   OldProdNum,    NewProdNum,      Updated
    text           int                           int                 Yes/no

I have another table (tblPrices) that contains a field: "ProdNum"  All of the values in ProdNum contain "OldProdNum" values which need to be replaced by "NewProdNum"

Ideally, I'd like to loop through all the products in my qryConvertProdNum and replace OldProdNum with NewProdNum.

I'm fairly new to VBA.  Is there a simple script that can accomplish this?


Start Free Trial