How do I get a macro to move to the next step after a conditional stop

scooteman

Registered User.
Local time
Today, 11:44
Joined
Nov 30, 2009
Messages
57
How do I macro to step to the next action after a conditional stop? I have a button to open a form to the record selected. I want a message box to show if no record is selected.

In my macro I have:

IsNull([employee_ID]) MSGBox
StopMacro

OpenForm
SearchForRecord
Close

When the [employee_ID] is null the message dispalys and the macro stops, however the open form button will nolonger work even if I select a record. How do I get my macro to work after it has stopped.
 
I found my own answer in Access Help. I was missing the three dots (...) that needed to be in the condition of the StopMacro. The dots are so small in the help screen I overlooked them.
 

Users who are viewing this thread

Back
Top Bottom