Changing the recordsource of a subform...

B

Brad Pears

I want to set the recordsource on a subform. THis particular subform is a
subform of a subform (i.e. parent-child-grandchild relationship...

The code I used was as follows...

forms![ParentForm]![SubformControlName].form!.[sub-subformcontrolname].recor
dsource = "something"

I just get an Access error when trying to set that. What is thte proper
sytax for setting the recordset on a sub-sub form?

Thanks,

Brad
 
T

tina

well, the syntax depends to a certain extent on where you are when you're
trying to set the property. but you could give this a try:

Forms![ParentForm]![SubformControlName]![sub-subformcontrolname].Form.Record
source = "something"

hth
 

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

Subform's RecordSource under Access 2007 sp1 2
changing the recordsource of a subform 2
Changing RecordSource of a subform 2
After changing the recordsource of a form, Disabling a button 1
changing recordsource continuous subform in vba 2
changing subform recordsource 1
Not linking subform 7
Acc 2007 Subform Recordset vs Acc 2002 Subform Recordset 2

Top