M
MikeC
Have created form for editing data in an historic database; form displays
data based on user inputted invoice#, which createsa tempory table and
"sub-table" of the data; on form have two action buttons-one to update the
data which deletes old data from table, appends data from temporary tables,
clears out temporary table, closes form and returns user to Main Switchboard;
the other action button is to cancel the update..have copied the previously
mentioned macro and merely deleted the statements to delete and append
opertions; the problem is that the cancel macro returns message "This action
can't be carried out while processing a form or report event. A macro
specified as the ONOpen, OnClose, OnFormat, OnRetreat, OnPage, or OnPrint
property setting contains an invalid action for the property"
Both macros are set up as OnClick within the properties. The form can be
closed by using the close gif or from file drop-down; the macro will run
properly if the form is closed and macro run from the macro window. Any help?
data based on user inputted invoice#, which createsa tempory table and
"sub-table" of the data; on form have two action buttons-one to update the
data which deletes old data from table, appends data from temporary tables,
clears out temporary table, closes form and returns user to Main Switchboard;
the other action button is to cancel the update..have copied the previously
mentioned macro and merely deleted the statements to delete and append
opertions; the problem is that the cancel macro returns message "This action
can't be carried out while processing a form or report event. A macro
specified as the ONOpen, OnClose, OnFormat, OnRetreat, OnPage, or OnPrint
property setting contains an invalid action for the property"
Both macros are set up as OnClick within the properties. The form can be
closed by using the close gif or from file drop-down; the macro will run
properly if the form is closed and macro run from the macro window. Any help?