REAL BASIC VBA syntax for retrieving results from query

I need to pull a result from a query and store it as a variable to be compared to criteria for an IF / THEN statement. What is the correct syntax for pulling a result, from say column 4 in a query, and saying if the record exists, do this. If it doesn't exist, do this -- in VBA? My query will only ever return 1 result or it will return 0 results.

If 1 result is returned, it needs to go to Time_OUT form. If 0 results are returned, it goes to Time_IN form. Thanks a ton in advance!

As a start, this is the code I have (The part where it says "If Me.MO_ID=Null" Then is where I don't know the correct syntax to use):

Please Login or Register  to view this content.

you cant store a query recordset in a variable to compare. Do you mean pull a value from a field from a query?
if so,
vID = Dlookup("[field]","query","[id]=" & txtbox )
if vID = 76 then...