Hi everyone - happy new year from an older first-timer
I'm not sure whether this should have been posted under Forms or Macros as my problem impinges on both so I've posted it here.
I've created a macro which successfully performs the following actions :-
1.Runs a Delete Query to clear data in a parameter table
2.Runs a Form to perform data entry to the parameter table
3.Runs a succession of Update and Append Queries which update database tables using the data in the parameter table
In the Form, I've disabled the standard Min, Max and Close buttons and have created a Command Button to Close Form. This has the effect of cleanly closing the form whereupon the macro continues processing the following Queries.
What I want to do (and have failed spectacularly) is to create another button which has the effect of cleanly closing the form but then immediately exiting the macro (without processing the following Queries).
The need for this arose when, having entered several rows of parameters, I realised that there were a number of errors in them and I didn't, after all, want the database to be updated.
Any help would be gratefully accepted
I'm not sure whether this should have been posted under Forms or Macros as my problem impinges on both so I've posted it here.
I've created a macro which successfully performs the following actions :-
1.Runs a Delete Query to clear data in a parameter table
2.Runs a Form to perform data entry to the parameter table
3.Runs a succession of Update and Append Queries which update database tables using the data in the parameter table
In the Form, I've disabled the standard Min, Max and Close buttons and have created a Command Button to Close Form. This has the effect of cleanly closing the form whereupon the macro continues processing the following Queries.
What I want to do (and have failed spectacularly) is to create another button which has the effect of cleanly closing the form but then immediately exiting the macro (without processing the following Queries).
The need for this arose when, having entered several rows of parameters, I realised that there were a number of errors in them and I didn't, after all, want the database to be updated.
Any help would be gratefully accepted
