Subform Recordsource

[Sech]

I am currently creating a form that uses a subform to display different sets of results, each using a different query (with the same field names). What code can I use to update the rowsource of the subform e.g. When an item is selected from a combo box?

I have tried Forms!subData.Rowsource = "qryDataSet1"
This give the error "Can't find the form 'subData'".

I have also tried Forms!frmResults.subData.Rowsource = "qryDataSet1" which does not work either

Does anyone know the correct line of code to use or if I have to set up any additional variables?

 

[BillPower]

In the After Update event of your combo if on a Main Form:

Me!subData.Form.Rowsource = "qryDataSet1"

Bill