Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-17-2018, 09:53 AM   #1
LukeSky
Newly Registered User
 
Join Date: Aug 2016
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
LukeSky is on a distinguished road
Event associated with combobox don't trigger

Hi, all.

I have two forms, one mainform and another form, form2, that is open from mainform.

In mainform, has one combobox and after inserting data, it trigger event executing macro "test" for showing a msgbox.

In form2, has another combobox that after inserting data, it trigger event executing vba code for changing data mainform's combobox. When close form2 for coming back to mainform, the macro is not triggered in event AfterUpdate.

My question is how I could do for forcing execute that event.

Is necessary that in vba code inserting?:

Code:
docmd.runMacro "test.msg"
If I was using vba for controling that combobox, I know that could use "cbo_AfterUpdate" but it is not my doubt. I would just like to know if there would be another way to force the execution of event AfterUpdate that has one "macro" instead of "Event Procedure".

I attach example database. Thanks in advance and forgive me my english that is not my native language.
Attached Files
File Type: mdb CCO.mdb (1.04 MB, 3 views)


Last edited by LukeSky; 04-17-2018 at 12:53 PM. Reason: [SOLVED]
LukeSky is offline   Reply With Quote
Old 04-17-2018, 11:16 AM   #2
LukeSky
Newly Registered User
 
Join Date: Aug 2016
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
LukeSky is on a distinguished road
Re: Event associated with combobox don't trigger

Ok, I found like do it.

I attach database with solution, hope that be useful for someone.

Thanks. Regards.
Attached Files
File Type: mdb CCO_Solution.mdb (244.0 KB, 0 views)

Last edited by LukeSky; 04-17-2018 at 11:24 AM.
LukeSky 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
[SOLVED] Which event Should I use as a trigger? brharrii General 3 04-18-2014 09:40 AM
Event trigger GaelicFatboy Forms 2 12-01-2011 12:54 AM
Trigger Subform Event tuna Forms 3 05-09-2010 04:33 PM
Non-Event to trigger a wav file BarryMK Modules & VBA 11 03-17-2008 05:50 AM
Trigger event when text box value changes lorveney Forms 7 11-20-2007 09:30 AM




All times are GMT -8. The time now is 05:50 AM.


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