Andrew Thorpe
Registered User.
- Local time
- Today, 15:09
- Joined
- Apr 18, 2009
- Messages
- 59
In a table (HOLIDAY), I have noted some dates as being official holidays. Within a form, I am trying to use the DLookup function to see if the date I am using is recorded as being a Holiday.
My line is:
If Forms!frmShift!StartDate = DLookup("HolDate", "HOLIDAY", "HolDate = Forms!frmShift!StartDate") Then.....
Unfortunately, it doesn't work. I have tried using # signs on each side of the date, but no joy. Would appreciate any help anyone can offer. Thank you. Andrew
My line is:
If Forms!frmShift!StartDate = DLookup("HolDate", "HOLIDAY", "HolDate = Forms!frmShift!StartDate") Then.....
Unfortunately, it doesn't work. I have tried using # signs on each side of the date, but no joy. Would appreciate any help anyone can offer. Thank you. Andrew