Prev: generate a confirmation email
Next: data entry in subform before mainform causes huge hassle, HELP!
From: AccessKay on 16 Apr 2010 10:56
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

From: Al Campagna on 16 Apr 2010 12:51
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" <AccessKay(a)discussions.microsoft.com> wrote in message
news:6502B75D-0257-4823-9D9D-57D9145B797B(a)microsoft.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
> do
> this.if it is possible?
>
> TIA,
> Kay
>


From: Beetle on 16 Apr 2010 13:30
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
>
From: Mark Andrews on 16 Apr 2010 14:33
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" <AccessKay(a)discussions.microsoft.com> wrote in message
news:6502B75D-0257-4823-9D9D-57D9145B797B(a)microsoft.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
> do
> this…if it is possible?
>
> TIA,
> Kay
>
From: AccessKay via AccessMonster.com on 16 Apr 2010 14:43
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/Forums.aspx/access-forms/201004/1

 |  Next  |  Last
Pages: 1 2
Prev: generate a confirmation email
Next: data entry in subform before mainform causes huge hassle, HELP!