use of Me. gives RunTime error

[olaf]

Hi!

When using the "me." keyword (for ex. me.FilterOn = True), I sometimes
(not always) get the error message:
"The expression yuo entered refers to an object that is closed or
doesn't exist."

I really wonder why. I use it in a Form-module, to reference the form
itself. The form is used as a subform in another form. Could that be
the reason?

Please help!
-Olaf

[Ed Robichaud]

I'm surprised that it works at any time. Below is a handy sheet to correct
syntax.



Syntax for main/subforms

For these examples:

Mainform is the name of the top level form

Subform1 is the name of the subform CONTROL on mainform

Subform2 is the name of the subform CONTROL on the 1st subform.


If you are on

Main form
Sub 1

To refer to a form property, like RecordSource

On Mainform
Me.RecordSource
Me.Parent.RecordSource

On Sub 1
Me!Subform1.Form.RecordSource
Me.RecordSource

On Sub 2
Me!Subform1.Form!Subform2.Form.

RecordSource
Me!Subform2.Form.RecordSource

To refer to a control

On Mainform
Me!ControlName
Me.Parent!ControlName

On Sub 1
Me!Subform1.Form!ControlName
Me!ControlName

On Sub 2
Me!Subform1.Form!Subform2.Form!

ControlName
Me!Subform2.Form!ControlName

To refer to a control property, like Enabled

On Mainform
Me!ControlName.Enabled
Me.Parent!ControlName.Enabled

On Sub 1
Me!Subform1.Form!ControlName.Enabled
Me!ControlName.Enabled

On Sub 2
Me!Subform1.Form!Subform2.Form!

ControlName.Enabled
Me!Subform2.Form!ControlName.Enabled

To refer to a subform control property, like SourceObject

On Mainform
N/A
N/A

On Sub 1
Me!Subform1.SourceObject
N/A

On Sub 2
Me!Subform1.Form!Subform2.SourceObject
Me!Subform2.SourceObject


If you are on

Sub2
Not in these forms

To refer to a form property, like RecordSource

On Mainform
Me.Parent.Parent.RecordSource
Forms!Mainform.RecordSource

On Sub 1
Me.Parent.RecordSource
Forms!Mainform!Subform1.Form.RecordSource

On Sub 2
Me.RecordSource
Forms!Mainform!Subform1.Form!Subform2.

Form.RecordSource

To refer to a control

On Mainform
Me.Parent.Parent!ControlName
Forms!Mainform!ControlName

On Sub 1
Me.Parent!ControlName
Forms!Mainform!Subform1.Form!ControlName

On Sub 2
Me!ControlName
Forms!Mainform!Subform1.Form!Subform2.

Form!ControlName

To refer to a control property, like Enabled

On Mainform
Me.Parent.Parent!ControlName.Enabled
Forms!Mainform!ControlName.Enabled

On Sub 1
Me.Parent!ControlName.Enabled
Forms!Mainform!Subform1.Form!ControlName.Enabled

On Sub 2
Me!ControlName.Enabled
Forms!Mainform!Subform1.Form!Subform2.

Form!ControlName.Enabled

To refer to a subform control property, like SourceObject

On Mainform
N/A
N/A

On Sub 1
N/A
Forms!Mainform!Subform1.SourceObject

On Sub 2
N/A
Forms!Mainform!Subform1.Form!Subform2.

SourceObject


"olaf" <ol***@runit.no> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

Hi!

When using the "me." keyword (for ex. me.FilterOn = True), I sometimes
(not always) get the error message:
"The expression yuo entered refers to an object that is closed or
doesn't exist."

I really wonder why. I use it in a Form-module, to reference the form
itself. The form is used as a subform in another form. Could that be
the reason?

Please help!
-Olaf

[David W. Fenton]

"Ed Robichaud" <ed*********@wdn.com> wrote in
news:bt*****************@monger.newsread.com:

I'm surprised that it works at any time. Below is a handy sheet
to correct syntax.

How completely idiotic.

Of course, Me.FilterOn should work in the module of a subform.

If you want to check it from outside that context, say while the
main form with the embedded subform is open, you can test it from
the Debug window with:

Forms!MainForm!SubForm.Form.FilterOn

Now, I've seen some complexities with filters in subforms, but
nothing that's insurmountable. Perhaps if the original poster could
indicate what exact line is causing the error, it would be more
easily diagnosable.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[Cathy Gilroy]

"Ed Robichaud" <ed*********@wdn.com> wrote in message
news:bt*****************@monger.newsread.com...

I'm surprised that it works at any time. Below is a handy sheet to
correct syntax.

Ed--Disregard David's post. He's having his period. (His asshole is
bleeding.) --Cathy

[Douglas J. Steele]

You probably should have mentioned that what you posted was copied from
http://www.mvps.org/access/forms/frm0031.htm at "The Access Web". In that
way, he could go there and see it formatted (and even download the doc
version)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Ed Robichaud" <ed*********@wdn.com> wrote in message
news:bt*****************@monger.newsread.com...

I'm surprised that it works at any time. Below is a handy sheet to
correct syntax.
"olaf" <ol***@runit.no> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

Hi!

When using the "me." keyword (for ex. me.FilterOn = True), I sometimes
(not always) get the error message:
"The expression yuo entered refers to an object that is closed or
doesn't exist."

I really wonder why. I use it in a Form-module, to reference the form
itself. The form is used as a subform in another form. Could that be
the reason?

Please help!
-Olaf

[XMVP]

According to Arvin Meyer MCP (Master Certified Plagiarist) you don't have to
mention where you stole stuff from.

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:vo********************@rogers.com...

You probably should have mentioned that what you posted was copied from
http://www.mvps.org/access/forms/frm0031.htm at "The Access Web". In that
way, he could go there and see it formatted (and even download the doc
version)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Ed Robichaud" <ed*********@wdn.com> wrote in message
news:bt*****************@monger.newsread.com...

I'm surprised that it works at any time. Below is a handy sheet to
correct syntax.
"olaf" <ol***@runit.no> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

Hi!

When using the "me." keyword (for ex. me.FilterOn = True), I sometimes
(not always) get the error message:
"The expression yuo entered refers to an object that is closed or
doesn't exist."

I really wonder why. I use it in a Form-module, to reference the form
itself. The form is used as a subform in another form. Could that be
the reason?

Please help!
-Olaf

[Ed Robichaud]

Thanks; I couldn't find that web page reference, but thought I'd sent the
info in HTML to preserve the doc formatting.
-Ed

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:vo********************@rogers.com...

You probably should have mentioned that what you posted was copied from
http://www.mvps.org/access/forms/frm0031.htm at "The Access Web". In that
way, he could go there and see it formatted (and even download the doc
version)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Ed Robichaud" <ed*********@wdn.com> wrote in message
news:bt*****************@monger.newsread.com...

I'm surprised that it works at any time. Below is a handy sheet to
correct syntax.
"olaf" <ol***@runit.no> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

Hi!

When using the "me." keyword (for ex. me.FilterOn = True), I sometimes
(not always) get the error message:
"The expression yuo entered refers to an object that is closed or
doesn't exist."

I really wonder why. I use it in a Form-module, to reference the form
itself. The form is used as a subform in another form. Could that be
the reason?

Please help!
-Olaf