set recordsource of subform from main form

  • Thread starter Thread starter Paul Doree
  • Start date Start date
P

Paul Doree

Hi,

Can anyone tell me if this is possible, and if so the syntax.

I've tried:

Forms!form1!form2subform.RecordSource = "tblabsence"
Forms!form1!form2subform.Requery

But the object doesn't support the property or method.

Cheers

Paul
 
Paul said:
Can anyone tell me if this is possible, and if so the syntax.

I've tried:

Forms!form1!form2subform.RecordSource = "tblabsence"
Forms!form1!form2subform.Requery
Click to expand...


Try using:

Me.form2subform.FORM.RecordSource = "tblabsence"
 
Back
Top