set recordsource of subform from main form

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
 
M

Marshall Barton

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"
 
Top