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