Question about Macros (1 Viewer)

StuartG

Registered User.
Local time
Today, 13:48
Joined
Sep 12, 2018
Messages
125
Good Morning

I am trying to create a macro that when a particular criteria is selected in a drop down it generates a pop up message where I can inform the user to complete a particular action.

in the tbl its setup as (Data type) "Short Text" with multiple Status's with that dropdown,

I need to create the macro when a user selects Cancelled/Duplicate.

How would I complete this?
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 21:48
Joined
May 7, 2009
Messages
19,169
you can use a macro on the AfterUpdate Event of the combo:

IF [comboName]="Cancelled/Duplicate"
MSGBOX ....
 

StuartG

Registered User.
Local time
Today, 13:48
Joined
Sep 12, 2018
Messages
125
Hi, thanks for the reply.

This worked.....
 
Last edited:

Users who are viewing this thread

Top Bottom