Syntax

Although I've taken 2 Access courses, have Cashman's book and read countless
posts; I'm still uncertain "wording" & syntax. I've created a form with a
comboBox and subform. I named:
the form "AllCountry",
the comboBox "ComboCN"
and the form used as the subform "BrSch"

In writing code should I use:
"cboComboCN" to refer to the combobox?
"Form!AllCountry" to refer to the Form?
"Form!AllCountry!Form!BrSch" to refer to the subForm?

And although I'm using the me. syntax/statement in my code I don't fully
understand it.

Thanks so much for any help yo can offer me.

Evan

Evan

"cbo" is a prefix you can use in naming a control. You don't need to use it
when you refer to something that doesn't include that prefix in its name.
One way to think of it might be if I referred to you as BobEvan. That isn't
your name, and few could figure out I meant you. Access is considerably
less intelligent and much more literal.

If you tell Access to look for something named "cboComboCN", it will look
ONLY for something with that name.

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Evan" wrote in message
...
Although I've taken 2 Access courses, have Cashman's book and read
countless
posts; I'm still uncertain "wording" & syntax. I've created a form
with a
comboBox and subform. I named:
the form "AllCountry",
the comboBox "ComboCN"
and the form used as the subform "BrSch"

In writing code should I use:
"cboComboCN" to refer to the combobox?
"Form!AllCountry" to refer to the Form?
"Form!AllCountry!Form!BrSch" to refer to the subForm?

And although I'm using the me. syntax/statement in my code I don't fully
understand it.

Thanks so much for any help yo can offer me.

Evan

Evan wrote:
Although I've taken 2 Access courses, have Cashman's book and read countless
posts; I'm still uncertain "wording" & syntax. I've created a form with a
comboBox and subform. I named:
the form "AllCountry",
the comboBox "ComboCN"
and the form used as the subform "BrSch"

In writing code should I use:
"cboComboCN" to refer to the combobox?
"Form!AllCountry" to refer to the Form?
"Form!AllCountry!Form!BrSch" to refer to the subForm?

And although I'm using the me. syntax/statement in my code I don't fully
understand it.

Thanks so much for any help yo can offer me.

Evan



I've found this reference very useful:

http://www.mvps.org/access/forms/frm0031.htm

Phil, London