DLookup Syntax Checkup

User avatar
burrina
4StarLounger
Posts: 550
Joined: 30 Jul 2014, 23:58

DLookup Syntax Checkup

Post by burrina »

Is this correct? Or am I missing something again?
DLookup("Monday", "tblweekdays", "Monday=-1") & Weekday(Now()) = vbMonday Then

User avatar
burrina
4StarLounger
Posts: 550
Joined: 30 Jul 2014, 23:58

Re: DLookup Syntax Checkup

Post by burrina »

It turns out that I should have used And instead of &

Thanks and Merry Christmas to all.