Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-12-2010, 09:38 AM   #1
Endojoe
Newly Registered User
 
Endojoe's Avatar
 
Join Date: Apr 2009
Location: Dallas, Texas
Posts: 20
Thanks: 2
Thanked 0 Times in 0 Posts
Endojoe is on a distinguished road
Send a message via ICQ to Endojoe Send a message via AIM to Endojoe Send a message via MSN to Endojoe Send a message via Yahoo to Endojoe Send a message via Skype™ to Endojoe
Selecting Options in Option Groups With Command Button

I have 5 option groups, several of them populate text box controls with standard verbiage in my form using the After Update event. There are a couple circumstances I want to create Command Buttons for that will select certain options in all the option groups in with a single click. Unfortunately the After Update Event will not fire in the option groups to fill the text boxes I need filled as well. Is there a way to force the after update event to fire after I place the value in the option groups with the command button?

Thanks in Advance

__________________
Using Office 2007 SP2 on Windows 7 Home Premium (32 Bit)
Endojoe is offline   Reply With Quote
Old 05-12-2010, 09:40 AM   #2
boblarson
Smeghead
 
boblarson's Avatar
 
Join Date: Jan 2001
Location: Oregon, USA
Posts: 32,068
Thanks: 97
Thanked 1,828 Times in 1,579 Posts
boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold
Re: Selecting Options in Option Groups With Command Button

If they are all on the same form you can just call the after update event of each option group:
Code:
YourOptionGroupNameHere_AfterUpdate
YourOptionGroup2NameHere_AfterUpdate
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
boblarson is offline   Reply With Quote
Old 05-12-2010, 01:20 PM   #3
Endojoe
Newly Registered User
 
Endojoe's Avatar
 
Join Date: Apr 2009
Location: Dallas, Texas
Posts: 20
Thanks: 2
Thanked 0 Times in 0 Posts
Endojoe is on a distinguished road
Send a message via ICQ to Endojoe Send a message via AIM to Endojoe Send a message via MSN to Endojoe Send a message via Yahoo to Endojoe Send a message via Skype™ to Endojoe
Re: Selecting Options in Option Groups With Command Button

Bob thanks a million!! I can't believe I couldn't figure that out in my research leading up to my post....but for some reason I just couldn't seem to find a clear explanation of how to achieve such a simple thing anywhere I looked. You are a Saint among mortals.

__________________
Using Office 2007 SP2 on Windows 7 Home Premium (32 Bit)
Endojoe is offline   Reply With Quote
Old 05-12-2010, 02:47 PM   #4
boblarson
Smeghead
 
boblarson's Avatar
 
Join Date: Jan 2001
Location: Oregon, USA
Posts: 32,068
Thanks: 97
Thanked 1,828 Times in 1,579 Posts
boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold
Re: Selecting Options in Option Groups With Command Button

Glad we could help.

__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
boblarson is offline   Reply With Quote
Reply

Tags
after update , command button , option group

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
The Department of Positive Out of Body Possibilities Tim Brewer The Watercooler 905 06-15-2009 10:10 AM
Combobox RowSource derived from 2 option groups batwings Modules & VBA 4 02-28-2008 08:47 AM
Option groups - possible to have duplicate values? ahuvas Forms 26 01-23-2008 06:09 PM
Option groups mousemat Forms 4 06-12-2003 01:50 AM
Option Groups??? wh00t Forms 1 07-19-2001 05:09 AM




All times are GMT -8. The time now is 03:17 PM.


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

Featured Forum post


Sponsored Links


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