Free E-Books

When Forms is followed by ! Access is being told that the next object name is the form object
that you want to refer to.
Additional keywords can be found in the next section, titled ???Special Keywords and Properties.???
As an example, say that you have a Description field (Description) that is in two different forms??”
frmProducts and frmSales, both of which are open on the screen at the same time. You want to
refer to the Description field in frmProducts. The way to specify this form is by use of the ! and the
Forms reserved word:
Forms![frmProducts]
or, more simply:
Forms!frmProducts
452
Programming Microsoft Access Part II
A Few Words about Controls and Properties
When you create a form or report, you place many different objects on the form??”fields bound
to text boxes, labels, buttons, check boxes, combo boxes, lines, rectangles, and so on.
As you select and place these objects on a form, each object is assigned a control name. Access supplies
a default control name according to predefined rules.


Pages:
935 936 937 938 939 940 941 942 943 944 945 946 947 948 949 950 951 952 953 954 955 956 957 958 959