The In Operator

[aperez54]

How do I do this?

I want:

If combobox.column(1) IN listbox.column(1) then
do what I want
Else
Exit function
End if

My head hurts I can't figure it out.

 

[aperez54]

I want to apply this on the after update event on the combobox. So that if it's a match, my listbox "stays". Otherwise, i do a requery on my listbox.

Hope that makes sense.

Combo box can have a value of 1 or 2 or 3
List box can have values of either 1, 2 or 1, 3 or 1 or 2 or 3 or 2, 3.

 

[randy700]

How about this? (NOT TESTED)

If Not IsNull(DLookup([Me.combobox.column(1)],"[i]Table/Query Listbox is built from[/i]") Then

Randy