Updating recordset in Access VBA
Posted on 2016-09-27
I am trying to update a record in a table based on the criteria in a field, let's say color. There may be many records that have the color RED but I only need to grab the first one to make an adjustment to the price. I am using the code below which is making a price adjustment but it is not grabbing a RED record, it is grabbing another color. This is a snippet of the code:
rstJournalShell![GLCOLOR] = strEntities(iCounter) 'this is an array that hold the color RED
.Fields("SumOfCoursePrice") = rstJournalShell.Fields("SumOfCoursePrice") - curBalance 'This is the price adjustment
Is there a way that I can grab a record that has the color RED and make the adjustment to that?