Click here to go to the downloads page.
Please select: VBAForBeginnersVideo16
Previous Video – VBA 15 – Loop Through A Recordset
Next Video – VBA 17 – Add New Record To A Recordset
Related Posts
01 – VBA Converting From A Macro02 – VBA Arguments
03 – VBA Objects and Properties
04 – VBA Events
05 – VBA Variables
06 – VBA Data Types (Integer, Long, Double)
07 – VBA Data Types (String and Date)
08 – VBA Built In Functions
09 – VBA Custom Functions
10 – VBA Debugging – Immediate Window
11 – VBA Debugging – Watch Window
12 – VBA If Function
13 – VBA Arrays
14 – VBA For Each Loop
15 – VBA Loop Through Recordset
17 – VBA Add New Record To A Recordset
Hi!
I am writing some code to loop through a recordset and update a field. However, I am having some difficulty making it work. The field I am trying to update is based on a query pulling from another table. Do you have any advice?
I would greatly appreciate it!
Hi Farren
Can you post the code you have written here and I will take a look and see what the issue is.
Without knowing anything else, with MS Access whenever you want to update fields that involve queries, you need to make sure that the id of the field is included in the query (this is how the query editor works anyway).