Can anyone provide an idea how I could automatically update the destination application (in this case is a Word mail merged document via automation) whenever there's a changed in the underlying table from my Access database without having to rerun the query? Typically only the field Description sometimes changes.
Step process:
Form1 (creates a parts list)
Form2 (saved records)
Parameter Query (creates a recordset from Form2)
Module (execute the code to perform mail merge)
Connection: maketable query
For example, if one of the row source from one of my listboxes in a form has changed, the changed is only visible in the underlying table and Form1 but does not update Form2 nor the maketable query? I was always told that a Dynaset Recordset is supposed to be the most flexible as they tend to update each other?
Desperate for answer and very confused?
Step process:
Form1 (creates a parts list)
Form2 (saved records)
Parameter Query (creates a recordset from Form2)
Module (execute the code to perform mail merge)
Connection: maketable query
For example, if one of the row source from one of my listboxes in a form has changed, the changed is only visible in the underlying table and Form1 but does not update Form2 nor the maketable query? I was always told that a Dynaset Recordset is supposed to be the most flexible as they tend to update each other?
Desperate for answer and very confused?
