If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Combo boxes like an option group?
Can you have three combo boxes on a search form and restrict the user to
choose only one, somewhat like an option group? How in general would you do this…if it is possible? TIA, Kay |
#2
|
|||
|
|||
Combo boxes like an option group?
Kay,
Sure, but there are many ways to do that. You could use a 3 checkbox option group control which of 3 combos are enabled/disbled .. Combo1 Combo2 Combo3 Ť Ť Ť === Option Group -- hth Al Campagna Microsoft Access MVP 2007-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "AccessKay" wrote in message ... Can you have three combo boxes on a search form and restrict the user to choose only one, somewhat like an option group? How in general would you do this.if it is possible? TIA, Kay |
#3
|
|||
|
|||
Combo boxes like an option group?
I'm going to assume that these are unbound combo boxes
since you said they are on a search form (don't do this if the are bound to fields). In the After Update event of each combo box set the other two boxes to Null; Private Sub Combo1_AfterUpdate Me.Combo2 = Null Me.Combo3 = Null End Sub Private Sub Combo2_AfterUpdate Me.Combo1 = Null Me.Combo3 = Null End Sub Private Sub Combo3_AfterUpdate Me.Combo1 = Null Me.Combo2 = Null End Sub -- _________ Sean Bailey "AccessKay" wrote: Can you have three combo boxes on a search form and restrict the user to choose only one, somewhat like an option group? How in general would you do this…if it is possible? TIA, Kay |
#4
|
|||
|
|||
Combo boxes like an option group?
Do an option group with three radio buttons and place a combo box next to
each radio button. On the after update event of the option group basically make the combo box next to the radio button that is selected visible and hide the other two. Alternatively keep them all visible and enable/disable the combo boxes (whichever makes more sense for the situation). That way to the user they are picking an option of which choice they want to make. Radio buttons indicate that only one choice is available (checkboxes indicate many choices are available). HTH, Mark Andrews RPT Software http://www.rptsoftware.com http://www.donationmanagementsoftware.com "AccessKay" wrote in message ... Can you have three combo boxes on a search form and restrict the user to choose only one, somewhat like an option group? How in general would you do this…if it is possible? TIA, Kay |
#5
|
|||
|
|||
Combo boxes like an option group?
Thanks Beetle...that worked great!
Al...I'm curious about what you suggested. Would you mind explaining it a little more? Thank you both for the help. Kay Beetle wrote: I'm going to assume that these are unbound combo boxes since you said they are on a search form (don't do this if the are bound to fields). In the After Update event of each combo box set the other two boxes to Null; Private Sub Combo1_AfterUpdate Me.Combo2 = Null Me.Combo3 = Null End Sub Private Sub Combo2_AfterUpdate Me.Combo1 = Null Me.Combo3 = Null End Sub Private Sub Combo3_AfterUpdate Me.Combo1 = Null Me.Combo2 = Null End Sub Can you have three combo boxes on a search form and restrict the user to choose only one, somewhat like an option group? How in general would you do this…if it is possible? TIA, Kay -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201004/1 |
#6
|
|||
|
|||
Combo boxes like an option group?
I think Mark just answered my question to you Al. I understand now. I'm
going to try it and see if this way works better. Thank you Mark! Mark Andrews wrote: Do an option group with three radio buttons and place a combo box next to each radio button. On the after update event of the option group basically make the combo box next to the radio button that is selected visible and hide the other two. Alternatively keep them all visible and enable/disable the combo boxes (whichever makes more sense for the situation). That way to the user they are picking an option of which choice they want to make. Radio buttons indicate that only one choice is available (checkboxes indicate many choices are available). HTH, Mark Andrews RPT Software http://www.rptsoftware.com http://www.donationmanagementsoftware.com Can you have three combo boxes on a search form and restrict the user to choose only one, somewhat like an option group? How in general would you [quoted text clipped - 3 lines] TIA, Kay -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201004/1 |
#7
|
|||
|
|||
Combo boxes like an option group?
Kay,
Mark's description is what I was referring to, but I would just enable/disable, rather than show/hide. Seems more visually logical to select Check1 and see Combo1 enable... and Combo2 and Combo3 disable... or select Check2 and see Combo 2 enable and Combo1 and Combo3 disable... etc... Also, the user can see that there are always 3 possible combos to select from. More of a "style" choice than a right/wrong method. -- hth Al Campagna Microsoft Access MVP 2007-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "AccessKay via AccessMonster.com" u59222@uwe wrote in message news:a6a0f93722d7a@uwe... I think Mark just answered my question to you Al. I understand now. I'm going to try it and see if this way works better. Thank you Mark! Mark Andrews wrote: Do an option group with three radio buttons and place a combo box next to each radio button. On the after update event of the option group basically make the combo box next to the radio button that is selected visible and hide the other two. Alternatively keep them all visible and enable/disable the combo boxes (whichever makes more sense for the situation). That way to the user they are picking an option of which choice they want to make. Radio buttons indicate that only one choice is available (checkboxes indicate many choices are available). HTH, Mark Andrews RPT Software http://www.rptsoftware.com http://www.donationmanagementsoftware.com Can you have three combo boxes on a search form and restrict the user to choose only one, somewhat like an option group? How in general would you [quoted text clipped - 3 lines] TIA, Kay -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201004/1 |
Thread Tools | |
Display Modes | |
|
|