Checking for Value in Query

[jgelpi]

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!

[RuralGuy]

A query *only* exists when it is run. How about looking at the DLookup() or DCount() functions for what you need.