Recent content by ccflanna

Thank you so very much! That worked perfectly!!!

Thank you so much. I'm almost there I think. I'm getting Compile Error: Else without If when I copy and paste that code in. I'm using Access 2007. Does that matter?

I was trying this but not working...Can you tell me what is wrong with this? I put it in the before update event procedure. Thank you so much!! ElseIf Not IsNull(DLookup("HoliDate", "Holidays", "[HoliDate]=#" _ & DivHearingDate & "#")) Then MsgBox "This is a Holiday" End If...

I have a form where the user enters a Hearing Date. I need to determine if that hearing date is a holiday. I have created a Holidays table with a list of our holidays in it. I wanted to enter an event procedure in the before update field of the hearing date to check the holidays table against...