Message box in a form if criteria met

[thedeadzeds]

Hi Guys, is the below possible?

If datDatefrom or datDateto in frmexample contains any of the dates in tblHoliday, then show a message box saying "you have selected a bank holiday" else do nothing

 

[pbaldy]

Sure, simplest might be using DCount().

http://www.theaccessweb.com/general/gen0018.htm

 

[Ranman256]

if Dcount("*","SELECT HolidayName FROM tHolidays WHERE (((tHolidays.DownDate) Between #" & vStartDate & "# And #" & vEndDate & "#))>0 then 
   msgbox "Holiday"
endif