Setting a subform's Recordset

[BAWC01]

Hi

I have a form and a subform.

I search using a combo to select the records I want and create a recordset

Set rstHUTF = dbsCurrent.OpenRecordset( _
              "SELECT STAMP, OPCOO, AREA, FLOW, USTATE, UCAT, WEIGHT, SHC, ULDID, INFLTID, OUTFLTID, DEST " _
            & "FROM HIS_HUTF " _
            & "WHERE ULDID like '" & GULD_Full_ID & "' " _
            & "ORDER BY STAMP DESC, ULDID DESC", dbOpenDynaset)

I then want to set the subform's data to that recordset

How do I do it

I have tried

   DoCmd.OpenForm "HUFT_ULD_Trace_Details", acNormal
   Set Forms("HUFT_ULD_Trace_Details").Recordset = rstHUTF

But this open a new form !!

Thanks

Phil

 

[BAWC01]

Figured it out

Set Forms!HUFT_ULD_TRACE!HUFT_ULD_Trace_Details.Form.Recordset = rstHUTF