SET subform Recordset

[Azita79]

Hi All,

I have a 3 layer form: frmMain(Main Form) which contains a Sub Form(frmSubLocation) which contains a sub form(frmsubCountyLocation)

frmMain ---> frmSubLocation ---> frmsubCountyLocation

now I have a Recordset in my frmMain which I need to use in the frmCountyLocation(subform of subform)

how do I set the Recordset of frmCountyLocation to the Recordset of the frmMain?

 

[Azita79]

Once again, I figured it out myself!

Set Forms!frmMain!frmSubView!frmSubCountyLocation.Form.Recordset = rstCL

Azita