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.
-
-
It sounds like you might want to post some code so we can see what kind of trouble you are actually having.
Typically in Access you should be able to bind your controls directly to a data source using ADO data controls.
Just drag the data control on your form, then over in it's properties change the data source to the table you would like.
One way you may want to start out too is by simply letting a wizard create a binded form for you, this way you can see how it works, and duplicate it or modify as needed.
Comment