NearImpossible
Registered User.
- Local time
- Yesterday, 22:00
- Joined
- Jul 12, 2019
- Messages
- 225
There are 8 records in the table and then an unbound field I am using for the Servings value, but for some reason, its only using the quantity value of the last record entered for the quantity value of all the other records, or if I select a row in the table and then click the update button, then it will use that value for all the records vs using each records value.
db attached
Any help is appreciated
thank you
Kevin
db attached
Code:
Set rs = CurrentDb.OpenRecordset("Select Quantity from [RecipesBuild]", dbOpenDynaset, dbSeeChanges)
While Not rs.EOF
With rs
.Edit
.Fields("Quantity") = Quantity / Servings
.Update
End With
rs.MoveNext
Wend
Any help is appreciated
thank you
Kevin