I have a situation where I need to check if a value exists in a query. If it does I just want to return a simple message box stating value already exists. Can anyone help me with this one?
If (value from combo box) = (Any value in the query) then
msgbox "You have already signed in today", vbokonly
combo42.value = ""
command2.setfocus
End If
That is what I'm looking to do. Your help is much appreciated!