Go Back   Access World Forums > Microsoft Access Discussion > Macros

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-12-2018, 12:04 AM   #1
StuartG
Newly Registered User
 
Join Date: Sep 2018
Location: United Kingdom
Posts: 28
Thanks: 5
Thanked 0 Times in 0 Posts
StuartG is on a distinguished road
Question about Macros

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?

StuartG is offline   Reply With Quote
Old 09-12-2018, 12:10 AM   #2
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 6,847
Thanks: 55
Thanked 2,183 Times in 2,094 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Question about Macros

you can use a macro on the AfterUpdate Event of the combo:

IF [comboName]="Cancelled/Duplicate"
MSGBOX ....
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 09-12-2018, 12:18 AM   #3
StuartG
Newly Registered User
 
Join Date: Sep 2018
Location: United Kingdom
Posts: 28
Thanks: 5
Thanked 0 Times in 0 Posts
StuartG is on a distinguished road
Re: Question about Macros

Hi, thanks for the reply.

This worked.....


Last edited by StuartG; 09-12-2018 at 12:20 AM. Reason: The previous reply was incorrect.
StuartG is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Question What is the best solution for enabling VBA and Macros bignate General 7 12-18-2013 02:41 PM
Enable Macros Requirement Question darknetone Modules & VBA 2 04-03-2008 09:56 AM
Question on conditions in macros hammerva Macros 1 11-20-2003 12:09 PM
Construction of Macros question? pablotx General 2 03-05-2003 10:50 AM
[SOLVED] Macros/Menu question AY Macros 3 09-20-2001 07:54 AM




All times are GMT -8. The time now is 10:11 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World