Chapter 15: Using Access Data Macros
559
Figure 15.5 also shows how IntelliSense helps you compose the expressions used in data
macros. In this case, the Name property requires a fully-qualified field reference, and as
soon as you start typing in a table name, a list of tables in the database appears. After you
select a table, the field names in the table appear as shown in Figure 15.5. Although not
all macro properties support this level of IntelliSense, most expressions are relatively easy
to compose properly.
FIGURE 15.5
CreateRecord adds a new record to any table in the database.Set Field macro action IntelliSense for Name propertyl EditRecord: As its name implies, EditRecord provides a way to change the content
of an existing record in the current, or another, table. EditRecord is ideal for situations
such as adjusting inventory levels when a product is sold or returned, or calculating sales
tax or shipping costs when the quantity field has been provided.