Getting Run-time error 3067 with the following SQL, any help is appreciated:
Code:"SELECT MasterList.FileNumber AS Value1, Now() AS Value2, fOSUsername() AS Value3, 'User Notified' AS Value4, 'User notified of completion.' AS Value5" & _ "FROM tblCommLog, MasterList WHERE (((MasterList.DateSentToVendor)= & [Forms]![frmUserNotifications]![DateSentToVendor] & AND ((MasterList.CurrentWF)=DRDO()));"