All,
Good morning. I've searched the forums for an answer to my problem but still being a novice I haven't found anything that makes sense to me.
I have a main form that contains Work Order information. Job #, date, customer, PO#, etc.
I have a subform with all of the detail of what to do to the job and the codes, etc. Inspect, repair, wheels, etc.
I have a template that updates the subform (table) according to certain procedures being done with the default lines to build on.
It is all working fine except....when the append query (template) is clicked the subform does not display the populated data unless you leave the record and come back.
How do I make it update itself withouth having to go to another record and return? I've tried to refresh but that's not working.
Thanks for your help.
Good morning. I've searched the forums for an answer to my problem but still being a novice I haven't found anything that makes sense to me.
I have a main form that contains Work Order information. Job #, date, customer, PO#, etc.
I have a subform with all of the detail of what to do to the job and the codes, etc. Inspect, repair, wheels, etc.
I have a template that updates the subform (table) according to certain procedures being done with the default lines to build on.
It is all working fine except....when the append query (template) is clicked the subform does not display the populated data unless you leave the record and come back.
How do I make it update itself withouth having to go to another record and return? I've tried to refresh but that's not working.
Thanks for your help.
