Can't reference subform

[J. M. De Moor]

Access 2000 .adp SQL Server 2000

I am trying to reference the Form in a Subform object but get the following
message:

"The expression you entered referes to an objectp that is closed or doesn't
exist."

The subform object is called sfmClientAddressList. The actual subform in
the Source Object is frmClientAddressList. The syntax I am using is:

Me!sfmClientAddressList.Form

It is being passed to a routine that assigns the Record Source to it...but
never gets that far because of the above message on the reference.

Any thoughts?

Joe De Moor

 

[Van T. Dinh]

(Just in case) You need to use the Subform*CONTROL* name in the reference:

Forms!MainFormName!SubformCONTROLName.Form

and not the name of the Form being used as the SourceObject.

Check and make sure that "sfrClientAddressList" is the SubformControl name.

 

[J. M. De Moor]

Thank you for your response. Yes. It is the control name. I triple
checked. Still get the message.