Trouble with the word 'me'

[lawdy]

I use the 'Me' word in a lot of code as



Me(pubStrCurrentCell).Caption = pubStrJobName ' pubStrCurrentCell is the name of an object on a form

It works real well in code on that form. However, if I want to use that same line in a module, it does not work at all. Is there anyway to reference an object in a modlue using a variable?

[June7]

Yes there is.

strForm = "My Form Name"
strControl = "My Control Name"

Forms(strForm).Controls(strControl).Caption

[John_G]

Hi -

Another way to do this would be to pass the form reference to the code module as an argument:

sub MySub(frm as form)
frm(pubStrCurrentCell).Caption = pubStrJobName ' pubStrCurrentCell is the name of an object on a form
end sub

then use

MySub(me)

to call it.

You might have to have pubStrJobName as a second argument to MySub

John

[lawdy]

Thanks to both of you for solving my problem.