Tab Control & Form Recordset access reference problem

[ceej]

I know this is a simple but tricky question.

I need to be able to reference the controls on a subform.

The form frmMain has a sub form named frmSub. The real name of the sub form is frmLineItems.

How do I reference the recordset without using ME?

This works: Set Me.Recordset = rst

That codes executes in the form load section.

 

[Remou]

The way to refer to a subform is via the subform control, which often has the same name as the form contained, but not always, so:

[tt]Me.[Name of Subform Control].Form.RecordsetClone[/tt]

 

[PHV]

Have a look here:

http://support.microsoft.com/?kbid=209099

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886