Alicia,
Macros?
You can run only one macro name from the property sheet's event line,
however each macro name can have many macros. Just open a macro sheet in
design view and place the next one on a line beneath the first macro. Rename
the macro sheet. Place the name of the sheet on the event line. All the
macros on the sheet will run.
Here is an example.
The macro sheet is named 'BeginMonth'.
On the sheet are several macros.
MsgBox
SetWarnings
RunQuery
SetWarnings
SetValue
BeginMonth would be written on the property sheet's event line.
Additionally, you can run any individual macro on that sheet by using the
following syntax:
MacroSheetName.IndividualMacroName
Why not use code instead?
It has the advantage of allowing error handling and is easier to make
changes.
