How do I use VBA Code to update a field in a table in Access? I am trying select case queries and do while loop queries. I don't know how to open the source and then update the field I need to.