Hi
I need to develop a report as I mentioned:
I have a report and when the report exit, the queries belongs to the table should be update automatically.
Any one help me in this?
Hi Thanks for your mail, I have sorted out this one and Ihave to sort out one more which is linked with it> as I mentioned...
I have a form linked with child form. when I select a key field in the main form the data according the key field pop up in a sub form and I set a query tobe add the data to their fields at the time the form closed by using Macro (on close event).before form closed query should run and add the new data intheir fields. Now I need to clear out the target table which contains this data before run a query (append query) by the selection key(serial No) Field in a form.
means when I closed form, query can run automatically & before run query the old data in target table should clear out & replace with new data.can u tell me how to solve it this issue?
