?? Run a query on exit of field with message ??

[eliotchs]

Hi

I have a form where I wwould like to run a query on exit of a field to check if the data exists, then close the form



Example::
User enters - Program, Month and Year

On exit of year a query will run which will check if a record exists with that program month and year, if it does then messagebox "Exists" and close form otherwise keep going


Thanks in Advance
Joe

[June7]

A DLookup() can accomplish this.

If Not IsNull(DLookup("ID", "tablename", "filter criteria here")) Then
...
End If