Search results

I hope that this helps someone. I split the reference and it is now OK. Dim MyFormA As Form Dim MyFormB As Form Set MyFormA = Me.Parent![frmOperationPO].Form Set MyFormB = MyFormA![frmOperationPOF].Form![frmOperationPOS].Form Set MyRS5 = MyFormB.RecordsetClone

When I remove the 2 lower level subforms from the reference, the Set statement is OK. Set MyRS3 = Forms![frmABTabOperations]![frmOperationPO].Form.RecordsetClone Does that suggest that property references are limited to 1 subform? Removing only the lowest subform still resulted in the...

I have the same problem, but in Access 2007 VBA. I have used the Builder in the Query definition, and copied its string into the VBA code. My observation over time is that there are subtle differences between the syntax in a Query and the syntax in VBA. I need a reference to the RecordsetClone...