I'm trying to delete the records where part of a field will = the value in a drop down box e.g.
DELETE tblReminder.*, tblReminder.memReminder, tblReminder.blnSystemGen
FROM tblReminder WHERE (((tblReminder.memReminder) Like '*[frmDeleteBaseData]![cboRecord]*') AND ((tblReminder.blnSystemGen)=True));
i know it should be deleting 3 records but it doesn't delete any, the problem seems to be the - Like '*[frmDeleteBaseData]![cboRecord]*'
Any help would be appreciated. Thanks
DELETE tblReminder.*, tblReminder.memReminder, tblReminder.blnSystemGen
FROM tblReminder WHERE (((tblReminder.memReminder) Like '*[frmDeleteBaseData]![cboRecord]*') AND ((tblReminder.blnSystemGen)=True));
i know it should be deleting 3 records but it doesn't delete any, the problem seems to be the - Like '*[frmDeleteBaseData]![cboRecord]*'
Any help would be appreciated. Thanks