Combo box with msgbox if the selected item is not in the record

[juniepiper27]

Dear Si,

I want a Messagebox to be appear if the selected item or if the input item in the combobox was not in the record.

I used this condition in combobox

="[asstnumbr] = " & "'" & [Screen].[ActiveControl] & "'"

but when I try this run code function in macro via IFF will become error

IIf([asstnumbr]<>"'" & [Screen].[ActiveControl] & "'",MsgBox("NO RECORD FOUND IN YOUR SEARCH"))


Please help me for this... thank you so much...

 

[JHB]

Do you not ask the same question here, (don't cross/double you are wasting people time)?
http://www.access-programmers.co.uk/forums/showthread.php?p=1391897#post1391897