Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-02-2018, 01:47 AM   #1
bhelmy
Newly Registered User
 
Join Date: Dec 2015
Posts: 58
Thanks: 9
Thanked 3 Times in 3 Posts
bhelmy is on a distinguished road
option buttom

hi
this my first time to use option buttom but i have one problem

i have 2 option (1 & 2 )

i need when user select 1 system auto unselect 2
and when user select 2 system auto unselect 1

However , i only selected


please

bhelmy is offline   Reply With Quote
Old 10-02-2018, 02:17 AM   #2
Minty
AWF VIP
 
Minty's Avatar
 
Join Date: Jul 2013
Location: UK - Wiltshire
Posts: 6,413
Thanks: 162
Thanked 1,732 Times in 1,702 Posts
Minty is a jewel in the rough Minty is a jewel in the rough Minty is a jewel in the rough
Re: option buttom

Did you use an Option Group ? If you did then the default behaviour is what you have described, so I'm slightly confused.
__________________
If we have helped please add to our reputation - click the scales symbol on the left, tick 'I approve' and leave a comment.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Minty is offline   Reply With Quote
Old 10-02-2018, 02:24 AM   #3
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,720
Thanks: 3
Thanked 2,081 Times in 2,036 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: option buttom

Look at the picture:
Attached Images
File Type: jpg Wizard1.jpg (37.2 KB, 47 views)

__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
The Following User Says Thank You to JHB For This Useful Post:
bhelmy (10-02-2018)
Old 10-02-2018, 02:40 AM   #4
bhelmy
Newly Registered User
 
Join Date: Dec 2015
Posts: 58
Thanks: 9
Thanked 3 Times in 3 Posts
bhelmy is on a distinguished road
Thumbs up Re: option buttom

thx
I get it
bhelmy is offline   Reply With Quote
Old 10-02-2018, 02:48 AM   #5
bhelmy
Newly Registered User
 
Join Date: Dec 2015
Posts: 58
Thanks: 9
Thanked 3 Times in 3 Posts
bhelmy is on a distinguished road
Re: option buttom

sorry but what is the value to true and false to write in VBA code (iF)
bhelmy is offline   Reply With Quote
Old 10-02-2018, 03:08 AM   #6
Minty
AWF VIP
 
Minty's Avatar
 
Join Date: Jul 2013
Location: UK - Wiltshire
Posts: 6,413
Thanks: 162
Thanked 1,732 Times in 1,702 Posts
Minty is a jewel in the rough Minty is a jewel in the rough Minty is a jewel in the rough
Re: option buttom

The option group will return the value of the selected item, you can then use that something like ;
Code:
SELECT CASE Me.YourOptionGroup 
     CASE 1              ' Option value 1
              Do something Here
     CASE 2               ' Option 2 
              Do something different here
      etc etc
END SELECT

__________________
If we have helped please add to our reputation - click the scales symbol on the left, tick 'I approve' and leave a comment.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Minty 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
Buttom/Combo Box To List Queries in Access Runtime bjblackmore Forms 1 03-25-2014 03:48 AM
Set caption and back color of a buttom using VBA in another button markzaal Forms 1 02-11-2013 03:53 AM
how to tab to a buttom on the main form a afterupdate event from a subform combo box Jaymin Forms 4 06-09-2012 03:18 AM
Is It Possible To Automatically Set The Report Page Margins (top, Buttom,left, Right) accesser2003 General 3 08-19-2007 09:45 AM
How to craet a buttom can add 50 data in the table bigbigi Forms 6 08-13-2007 11:12 PM




All times are GMT -8. The time now is 09:59 AM.


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