Hi,
I'm using Access 2003. I have a form (form1) that opens another form (form2) that contains a subform (form3).
The vba code on form1 needs to set the record source for form 3. I know Access is finding the form because I hide
some columns:
However, when I try set the recordsource on form 3, I get the error "438 - object doesn't support this property or method". I've tried various ways of referencing it. Here's what I'm doing and I don't understand why it doesn't work:
Does anyone know what I'm doing wrong?
I'm using Access 2003. I have a form (form1) that opens another form (form2) that contains a subform (form3).
The vba code on form1 needs to set the record source for form 3. I know Access is finding the form because I hide
some columns:
Code:
For I = 1 To 11
Forms![form2]![form3]("Text" & I).ColumnHidden = True
Next I
However, when I try set the recordsource on form 3, I get the error "438 - object doesn't support this property or method". I've tried various ways of referencing it. Here's what I'm doing and I don't understand why it doesn't work:
Code:
Forms![form2].Form![form3].RecordSource = strSQL
Does anyone know what I'm doing wrong?