Hi
I have a form with sub form contains 9 Append queries. I have set them to be run automatically when the form closes by closing event with macros. now I have to set up as before query runs the target table should update with new data by clear out the old data every time when query runs.
Can any one help me to fix this issue?
ThanQ
I have a form with sub form contains 9 Append queries. I have set them to be run automatically when the form closes by closing event with macros. now I have to set up as before query runs the target table should update with new data by clear out the old data every time when query runs.
Can any one help me to fix this issue?
ThanQ
Last edited:
