Deleting records 1

[GLENEE]

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

 

[dhookom]

Are you trying to do this from code or in a saved query?
Try:

DELETE tblReminder.*
FROM tblReminder 
WHERE memReminder Like '*' & [frmDeleteBaseData]![cboRecord] & '*' AND blnSystemGen=True;

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[GLENEE]

I've tried both ways. By putting the & before and after [frmDeleteBaseData]![cboRecord]the query prompts me for a value even though the form is open and a value has been selected from the drop down box cboRecord.

 

[dhookom]

Sorry, I copied and pasted without proofing. Try adding "Forms":

DELETE tblReminder.*
FROM tblReminder 
WHERE memReminder Like '*' & [red]Forms[/red]![frmDeleteBaseData]![cboRecord] & '*' AND blnSystemGen=True;

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[GLENEE]

Yea, that's it. The Forms! was missing. Thanks for your help.