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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

main form/subform 1
How Me works? 13
Forms property using varables 2
Subform RecordSource Problem 2
Form get User defined type not defined and stops 2
Bookmarking a record in a subform. 4
Filter main form to records with no related records in subform,maintain updateable recordset 4
Access 2007 - Recordsource & Subform 19

Top