form property for subform

[shifty shaker]

I'm encountering an error on attempting to set the form to the subform on a
form

dim frm as form
set frm = forms!frmmainform!frmsubform

type Mismatch in above line
and hence I cannot do this:

rs=frm.recordsetlone.

[John Welch]

You need to refer to the name of the suborm control, not the name of the
subform itself, like this:

Dim frm As Form
Set frm = Forms!frmMainForm!SubformControlName.Form

"shifty shaker" <SS***@pioneers.net> wrote in message
news:rG************@news02.roc.ny...

I'm encountering an error on attempting to set the form to the subform on
a form

dim frm as form
set frm = forms!frmmainform!frmsubform

type Mismatch in above line
and hence I cannot do this:

rs=frm.recordsetlone.

[shifty shaker]

Yes..thanks John I figured it out a little while after I posted - went to
work and checked the Access Help and found what you mentioned.
"John Welch" <john(remove)welch@cal(remove)central.com> wrote in message
news:do********@enews4.newsguy.com...

You need to refer to the name of the suborm control, not the name of the
subform itself, like this:

Dim frm As Form
Set frm = Forms!frmMainForm!SubformControlName.Form