What does ME mean in VBA ?

D

Dennis

It is just a short way of referring to the current form or report you are
working with.
If you are on a form called Form1 with a control name called Control1,
instead of writing [Forms]![Form1]![Control1] = .... you can put
Me.Control1 = .....
 
B

BruceM

Being from Maine (abbreviated ME) this was especially bewildering when I
first looked at VBA code, which as it happened contained things like
Me.Location where Location is a town in Maine. Even more puzzling until I
got the drift was Me!Location. I mean, Maine is a nice place, but I couldn't
understand the reason for the excitement in computer code.

Dennis said:
It is just a short way of referring to the current form or report you are
working with.
If you are on a form called Form1 with a control name called Control1,
instead of writing [Forms]![Form1]![Control1] = .... you can put
Me.Control1 = .....

Martin said:
What does ME mean in VBA ?

Thanks!
 
Top