How to use Me!

[hrabbit]

Hi All,
I know this is a very basic question but I can't find the answer in the help files or other resouces I have. Though it's used in the book I am using (Access 2000 Programming - Weekend Crash Course) it is not ever explained.

What exactly does Me! refer to? Is it the current form?
Thanks very much for your help.
Rebecca

 

[Jack Cowley]

Me refers to the currently active form. It can be used as a shortcut for [Forms]![FormName] when referring to a control on a form. Me![ControlName] replaces [Forms]![FormName]![ControlName].

To find Me in help go to any existing code that you have and type in Me. Place the cursor on the word and press the F1 key and Access2000 should give you more details.

HTH,
Jack

 

[TGHockett]

Thanks for asking the "hard" VBA questions so I don't have to always look to be the dunce

And thanks Jack for the "easy" answer!

TGH

 

[hrabbit]

I'm new to Access programming (could you tell?) so I'll be competing for the champion dunce position.

I greatly appreciate the help and the clear answers.
Rebecca