Syntax

  • Thread starter Thread starter Evan
  • Start date Start date
E

Evan

Although I've taken 2 Access courses, have Cashman's book and read countless
posts; I'm still uncertain re: "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 said:
Although I've taken 2 Access courses, have Cashman's book and read countless
posts; I'm still uncertain re: "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
Click to expand...

I've found this reference very useful:

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

Phil, London
 
Back
Top