hi all
i just wanna make sure im doing something correct
so i have a form, and in that form i have 9 sub forms that are set as continuous forms
although the data comes from the same table, i have used 9 different queries, for the sub forms, to filter the data correctly is this the correct way of managing sub forms?
what i want to achieve with this form is store the data historically, so i can return the data from the sub forms, based on the main form date created.
i have thought of using an append query to store the data in another table, but how do i do this so the sub forms return the original values?
i just wanna make sure im doing something correct
so i have a form, and in that form i have 9 sub forms that are set as continuous forms
although the data comes from the same table, i have used 9 different queries, for the sub forms, to filter the data correctly is this the correct way of managing sub forms?
what i want to achieve with this form is store the data historically, so i can return the data from the sub forms, based on the main form date created.
i have thought of using an append query to store the data in another table, but how do i do this so the sub forms return the original values?