Can someone please assist me:
i am trying to use a dlookup function that seacrhes for a record with todays date..
eg:
Dim today As Date
today = Format(Now(), "mm / dd / yyyy")
If (Nz(DLookup("Incoming Customer", "EnquiryManagement", "datevalue(TodaysDate)= " & DateValue(Me.date) & " "))) > 0...