hi
so i have a form with 8 unbound sub forms, each sub form is attached to a select query, each query is filtered uniquely, such as one date field is filtered to show just todays events,
the date that is displayed in these sub forms can be changed for the source table, so i need the ability to save the current data in the sub forms, to a unique id, so it can be viewed historically.
i thought of using a append query. so my question is can i create an append query that has multiple select queries?
so i have a form with 8 unbound sub forms, each sub form is attached to a select query, each query is filtered uniquely, such as one date field is filtered to show just todays events,
the date that is displayed in these sub forms can be changed for the source table, so i need the ability to save the current data in the sub forms, to a unique id, so it can be viewed historically.
i thought of using a append query. so my question is can i create an append query that has multiple select queries?