Free E-Books

The Syntax is:
Forms!frmContacts
n Form: The current active form??”used to access an object on a sub form within a specific
form. The syntax is:
Forms!frmMyForm.mySubFormObject.Form!theControlName
n Reports: The complete collection of open reports in a database??”used to specify a specific
report. The syntax is:
Reports!rptContacts
n Screen: The Screen object is used for the particular form, report, or control that has
focus. The Screen object provides many properties to reference objects that currently
have the focus. The syntax is:
n Screen.ActiveForm: Used for active form
n Screen.ActiveReport: Used for active report
n Screen.ActiveDatasheet: Used for active datasheet
n Screen.ActiveControl: Used for active control
Be aware that a reference to a Screen property may be invalid if the referenced object
(such as ActiveDatasheet) is not open on the screen, and does not have focus.
NOTE
454
Programming Microsoft Access Part II
n Me: Me is a special property that is used to reference the active form, report, or class module.


Pages:
941 942 943 944 945 946 947 948 949 950 951 952 953 954 955 956 957 958 959 960 961 962 963 964 965