RecordsetClone on a subform

  • Thread starter Thread starter johnb
  • Start date Start date
J

johnb

Hi, I'm trying to reference a record source linked to a
subform using Access XP.
Set rec = Forms!frm_TopFormName.RecordsetClone works fine
at the Topform level but when try refer to the subform
rows with
Set rec = Forms!frm_TopFornName!
frm_SubFornName.RecordsetClone

I get "object doe not support this property of method".
Any suggestions on the correct syntax?

TIA johnb
 
Try:
Set rec = Forms!frm_TopFornName.frm_SubFornName.Form.RecordsetClone

That's a reference to the form in the subform control.
 
Back
Top