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

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" <olafn (AT) runit (DOT) no> wrote

"Ed Robichaud" <edrobichaud (AT) wdn (DOT) com> wrote in
news:bt4Le.976$MP5.79948 (AT) monger (DOT) newsread.com:

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

"Ed Robichaud" <edrobichaud (AT) wdn (DOT) com> wrote

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

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" <edrobichaud (AT) wdn (DOT) com> wrote

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



"Douglas J. Steele" <NOSPAM_djsteele (AT) NOSPAM_canada (DOT) com> wrote

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 (AT) NOSPAM_canada (DOT) com> wrote