Code to Validate Combo Boxes on a Form

[TheNoocH]

I have 9 combo boxes cmbOption01 to cmbOption09.
What i want to do is validate that none of the 9 option boxes have the same value (note: not all option boxes will be selected all the time...thus multiple ones can have blank).

I got the theory to work using:

Sub Private cmbOption02_Change()
If Me.cmbOption01.Value=Me.cmbOption02.Value Then
MsgBox "Duplicate option entered"
End If
End Sub

My issues are how do i do it so i can evaluate all 9 options at once and ignore when they are blanks.
Plus is the OnChange the right place to put this?

Any help would be great.

 

[mdmilner]

I personally like the _afterupdate event because it's after the user has changed the value of the combobox.

What you could do is iterate through all 9 combo-boxes and check each. A cleaner way to do this would be to build SQL that excludes all 'prior' values but it can get messy and cumbersome fast.

Mike