Access 2013 VBA Code To Check if a Value Exists in a Query

I have an application with a text box and a sub-form. The sub-form shows the results of a query. I want to be able to type in a value in the text box and see if that value exists in a certain column of a query.

I then want to put this into an IF statement.

If
    txtbox1.text matches value in query
    then run regular routine.
Else
    msgbox"This serial number does not exist in this query."
End If