Fill datasheet subform based on selection in parent form

[jwillet1]

What I have is a form that takes in information regarding test data. Each test run can record data for multiple requirements. I am able to pull all data fine, however in order to make it easier on the user i was hoping to populate the requirements subform based on a selection of "test group" in the main form.

Commonly run together requirements can fall in to groups. I have a selection box for these groups in the main form and a table that stores these group id's and group setup. Is there a way to autofill the tables records that the subform is linked to based on the selected test group?

 

[gbnz]

Try building a query from the criteria on your form and then run it. Then with the query running go to the create tab >other forms dropdown and choose datasheet. That will create a new datasheet form > save it, close it and then drop it onto your form as a subform.

 

[jwillet1]

That suggestion did work for populating the subform. However the issue now is that, the subform that becomes populated needs to input that data into tbltestdetails, linked on the testID from tblTestData. The data from the main form is input in to tblTestData just fine, however no data is input in to tblTestDetails.

To clear it up a bit i have attached some pictures of the forms, subforms, queries, and tables. Hopefully it is clear enough.

 

[gbnz]

I am sorry but I am not sure what you are trying to do...

Please break it down step by step maybe I can understand better of what you are wanting to accomplish. Thanks