Display Msg Box Based Upon Query

[dzirkelb]

I got it to work by chaning my sql statement to be the same as what the form uses to pull data...so, if there is no data, then it doesn't do the dlookup, which is exactly what I wanted. Thanks for all your help, I just didn't think it through exactly correctly!