Me!

[joesmithf1]

Hello All,

I have seen someone that write a script like this:

If menulistONE.Visible = True And NullToZero(menulistONE) = 0 Then
Me!menulistONE.Visible = False
ElseIf menulistTWO.Visible = True And NullToZero(menulistTWO) = 0 Then menulistTWO.Visible = False

What does the Me! do in this case? I have search online and Access Help, but can't seem to find it anywhere.

Thank you!

 

[Steve R.]

"Me" is a reserved word to identify the current (active) form so that you do not have to refer to the form by its actual name. Think of it as a type of shorthand.

Forms!MyFormName.ControlName = SomeValue

Equivalent to:

Me.ControlName = SomeValue