Database Reference
In-Depth Information
Property
Sheet button
ID column
selected
Event tab
383
On Click event
Build button
FIGURE E-19
Creating the macro associated with the On Click event for the ID field
Figure E-20 shows the macro associated with the On Click event for the ID field in the Customer form.
When a user clicks the ID field for a record, the macro will open a pop-up form that contains the data for
that record.
Close button
Save button
Macro for On
Click event
FIGURE E-20
Macro Designer for the On Click event for the ID field
NOTE
The macro shown in Figure E-20 shows field names enclosed in square brackets (for example, [CustomerNum]). When used in
a macro, square brackets are required for field names that contain spaces. For example, you would write a field named
“
Customer Number,
”
with a space between the words, as [Customer Number] when using it in a macro. Because the
CustomerNum field name does not contain any spaces, you could write it without the square brackets when using it in a
macro. However, you can enclose field names in square brackets, even when they are not required.
