how to run an sql from a subroutine in a subform (1 Viewer)

[martinr]

I'm trying to run an sql update query (in VBA) to update values in a table, from calculated field values in a subform (using a query as a record source).
Is this possible , and if so, can I call the subroutine from the parent form, and
what would be the correct syntax for the VBA sql string (i'm guessing it would be a docmd.runSQL sqlstringname )??
Any suggestions welcome...

 

[Galaxiom]

The requirement of updating a table with calculated values sounds like a normalization problem.

You should explain your data structure and why you would need to do this.