Where can I get more information on this pls?

[Buakaw]

Hi,


I am looking at the VB code of an Access project, and one line of the code says:

Dim strWhere As String
strWhere = "[SrvID] = " & Me![SrvID]

I searched Help and found the documentation for the implicit variable "Me".

However, where can I learn more about what Me![SrvID] means or what it refers to? What does the "!" character do, and what do I search to find more info on it?

I tried searching Me![SrvID] but nothing came up.

Thanks.

[RuralGuy]

Me is shorthand for Forms.YourFormName which as you can see is a reference to the current form. "!" is shorthand for the default collection which is the Controls collection in tha case of a Form. In your case the Me![SrvID] in long hand would be: Forms.YourFormName.Controls.SrvID replacing YourFormName with your actual form name of course. SrvID is a ControlName on your form and (here's where it gets a little tricky) if there is no Control on your form named SrvID then Access will point to a Field in your RecordSource named SrvID. Clear as mud, right?

[Buakaw]

Thanks! If I wanted to read the documentation on this on Access Help, what should I search for? Not on "Me" but on the "!" shorthand.

[weekend00]

I want to know what are the differences between "!" and "."

I always use "." and never use "!" except in DAO.recordset because I can't use "." to get recordset's field. But I use only "." in form's controls.

Is there any difference between me.SrvID and me!SrvID?

[RuralGuy]

This link might help:
http://blogs.office.com/b/microsoft-...t-or-bang.aspx

[weekend00]

Very good article, helpful.
Thank you RuralGuy.

[Buakaw]

Yes, thanks for coming through again RuralGuy!