Changing the recordsource of a subform...

  • Thread starter Thread starter Brad Pears
  • Start date Start date
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
 
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
 
Back
Top