I have a query that contains two fields; SID & Status.

I have set my criteria to only include the blank status'.

I now would like to set a validation rule to my form so when the user attempts to input the SID it checks to see if it exists in the query results. If not, return a message box informing the user that the SID has already been completed.