Look for records not there

[Forrest]

My table has a date field. I would like my form to search for a record with yesterday's date and if it is not found display a msgbox. How do I get it to look for records that aren't there?
Thanks

 

[ShaneMan]

My table has a date field. I would like my form to search for a record with yesterday's date and if it is not found display a msgbox. How do I get it to look for records that aren't there?
Thanks

Hey Forrest,

Your really not looking for "records that aren't there", it's more that your counting records that are found and if there are none then fire your message, so with that being said what you would want to do is go ahead and have your search form filter according to yesterdays date, do a RecordCount of what it found and if it equals 0, then fire your MsgBox.

As usual, there are probably more ways than this one to get what you want accomplished, this is the way I am doing it in the current dbase I'm building.

HTH,
Shane