Do I have a good one for you lol
This recordset won't update - when it should be.
I don't want to explain the point of this project more than: there are 2 tables
1.) Data_Pull1: The raw data
2.) CleanDataTable: A table that holds the FIELDS in Data_Pull1, with other pieces of information for each field
3.) Table_DataTypeEnum: Lists the dao data type enum and their string reference, not important for troubleshooting
The point is that each RECORD in CleanDataTable is a FIELD in Data_Pull1. It will be iterated through to UPDATE each RECORD in Data_Pull1 for each FIELD. (round the number)
Except thats not happening: Access won't update the record - it updates ONLY 1 field.
And you are saying, "you forgot a .MoveNext" - Nope.
Also to prove that it should be updating: there is a string readout that prints at the end showing each field that was set to update yet if you look at the table, it is UNCHANGED except one field.
So, i am lost.
To start the process:
Open form CleanDataForm and put a value in the txtbox for rounding and hit apply.
The value doesn't matter because the code sets the rounding to 2 anyway for demonstration.
The msgbox will appear.
Notice all the fields that should have updated.
Close msgbox.
See table - no changes to the data.
Appreciate the help!
regards.