johnnylogistics
Technical User
I want to automatically reset a Macro that performs a DoesIncrement function every time the macro is run.
The Macro is written as follows:
"Function DoesIncrement(AnyValue)
RecordNum = RecordNum + 1
DoesIncrement = RecordNum
End Function"
I currently go to the tool bar in the Design function of the Macro and manually select the Run ---> Reset before running a query that calls this macro. Is there any way I can automatically reset the macro automatically?
The Macro is written as follows:
"Function DoesIncrement(AnyValue)
RecordNum = RecordNum + 1
DoesIncrement = RecordNum
End Function"
I currently go to the tool bar in the Design function of the Macro and manually select the Run ---> Reset before running a query that calls this macro. Is there any way I can automatically reset the macro automatically?
