Trying to use ME correctly (1 Viewer)

[homer2002]

I have a module that I am using.. to cut a long story short, I need to be able to reference the form that calls the module.

i.e.

I have a form (ME)


the form calls DoSomthing()

I want the DoSomthing() function to change the caption of a label

I figured the code in the module would go somthing like this.

private function DoSomthing()
Forms!Me!lblMyLabel.Caption = "Hello, world"
end function

---- But of course it didn't work. Can anyone tell me how to reference this correctly, cheers.

 

[Fuga]

Maybe like this:

Me.lblmylabel.caption = "hello world"

or maybe like this:

forms!yourformname.lblmylabel.caption "hello world"


Fuga.

 

[Mile-O]

Me is a reference to the form or class that can only be used within its module.

You can pass like this:

Dim vTest As Variant
vTest = DoSomething(Me.Name)

and in the module:

Public Function DoSomething(ByVal strForm As String) 
    Forms(strForm).lblMyLabel.Caption = "Hello, world" 
End Function

 

[Mile-O]

Have a read of this too.

 

[namliam]

Me = the form

private function DoSomthing()
Me.lblMyLabel.Caption = "Hello, world"
end function

Will do the trick directly, but read the link Mile gave anyway...

Regards

 

[Mile-O]

I have a module that I am using.. to cut a long story short, I need to be able to reference the form that calls the module.

It never really sais if the function was in the form's class module or a standalone module.