Good morning, I have a main form with a subform. The subform is a continuous form which is filtered from the main form. I then use the inbuilt Access Filters (right click in the text box) to narrow down the records shown in the subform.
Once the records are filtered down I would like to copy those records using a button on the main form (shown as Print Appln Charts on the screenshot) to a temporary table to use as a base for a report.
Is this possible?
I have tried using an append query but it copies the unfiltered records of the subform e.g. when I open the forms there may be 30 records showing in the subform I then filter this down to say 10 which I want to copy but the append query copies 30 records to the new table.
Screenshot attached for guidance
Thank you in advance for any help.
Once the records are filtered down I would like to copy those records using a button on the main form (shown as Print Appln Charts on the screenshot) to a temporary table to use as a base for a report.
Is this possible?
I have tried using an append query but it copies the unfiltered records of the subform e.g. when I open the forms there may be 30 records showing in the subform I then filter this down to say 10 which I want to copy but the append query copies 30 records to the new table.
Screenshot attached for guidance
Thank you in advance for any help.