asked on

Invalid use of Me. keyword

Experts,
The following code is in a module I call modChangeVisiblty:

Me.LineCode.Locked = False
Me.ScrapTicketDate.Locked = False
Me.ScrapTicketShiftNumber.Locked = False
Me.LineCode.SetFocus
Me.txtBOMDescribed.Visible = False
Me.lblChargedTo.Visible = False
Me.LineCodeID.Visible = False
End Sub

The code worked fine until I placed it is the module and called it

Call mChangeVisiblty and received the Invaalid use of M.e keyword error

ASKER CERTIFIED SOLUTION

Rey Obrero (Capricorn1)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mbizup

Me is a shorthand notation for a form.

You need to explicitly specify the form when you put this in generic module not associated with the form.

SOLUTION

Jim Dettman (EE MVE)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

TextReport

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

mbizup

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Frank Freese

ASKER

cap,
got an error Compile error: Argument not optional at

Call mChangeVisibilty

Frank Freese

ASKER

cap, saw that error...correcting and still working on problem

Frank Freese

ASKER

changed to code in mChangeVisibilty and thought Compile eror would go away. still there, at Call mChangeVisibility

With Forms(sForm)
.visible=True
.lblChargedTo.visible=true
.
.
.
End With
End Sub

TextReport

Check out the CodeContextObject, much easier as it referes to the object the code is running from.
Cheers, Andrew

Rey Obrero (Capricorn1)

change way you call the sub to include the name of the form

Call mChangeVisibilty(me.name)

or

Call mChangeVisibilty("Form1") 'where Form1 is the Name of the form

Frank Freese

ASKER

ok folks....i think i found MY error.
Call changeVisibilty
should have been
Call changeVisibilty(sForm)

Frank Freese

ASKER

thanks for the information and allowing me the time to understand what i did wrong.

Patrick Matthews

Being a little nitpicky... Me is a shorthand reference to the class a class module is bound to. You often see it
used in Form or Report modules, which are really class modules. If you create your own classes, the Me
keyword when used in those class modules would refer to the class defined in the module.

:)

TextReport

matthewspatrick, agreed but explaining the quote below from the Access Help on ME to most users is a waste of time.

"The Me keyword behaves like an implicitly declared variable. It is automatically available to every procedure in a class module. When a class can have more than one instance, Me provides a way to refer to the specific instance of the class where the code is executing. Using Me is particularly useful for passing information about the currently executing instance of a class to a procedure in another module. For example, suppose you have the following procedure in a module:"

Cheers, Andrew