I have a sub form which needs 2 fields updated one is numeric and the other is text both are using text boxes as the control source. I have searched the web and my book references but stuck on getting the input from the user for these two fields and updating the input at my target table.

One question is can I update my target table using the dynaset and form I used to build my resultant query? You see, I am successfully creating a dynaset with a button that runs a select query. The resultant dynaset however needs to be connected to the table with the 2 fields I want to update because its form has the 2 textbox control sources.

At this point, I am thinking the only way to get at my target table is with VBA. Am I correct? And if I am correct, then there are many things to decide; one is whether to update onclick or after update, but that would be minor I am hoping.

This may be simple to someone out there, but for me at the moment its been killing me for at least the past weekend and now into this week!

Will someone please point me in the right direction? An example of a subform resultant subsequesntly passing update information to a table would be perfect