reference Recordsource subform Access 2007

[matrixindicator]

Don't know why Access is complaining to about the RecordSource Reference. It works fine in Access 2000 but transfering it to Access 2007 he is complaining. What to do about it ?

Forms!F01_ORDER![FS_T02_ORDER].Form.RecordSource = "QS_T02_ORDER"

 

[KiaruB]

try this

Forms!frmMaster.Form!frmSub1.Form.RecordSource =

 

[MajP]

Sorry KiaruB that is incorrect. The only way to reference a subform is through the subform control's form property. At best
Forms!frmMaster.frmSub1.Form.RecordSource
not
Forms!frmMaster.Form!frmSub1.Form.RecordSource

forms!formsCollectionIndex.subFormControlName.Form

 

[SkipVought]

FYI matrixindicator,

MS Access questions are better addressed in one of the many MS Access forums in Tek-Tips, such as...

Forum702
Forum705

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]