How to use input paramters in query again in macro

[zadkiel]

Dear all,

I have a delete query for users to delete a specific period of data. the SQL of the query is:

DELETE [TRADE].[TRADE_DATE]
FROM TRADE
WHERE ((([TRADE].[TRADE_DATE]) Between [Enter a specific start date (dd/mm/yyyy)] And [Enter a specific end date (dd/mm/yyyy)]));


And I want to use macro to display a msgbox to let user to confirm the date he has entered, I create the condition of CancelEvent like this:

MsgBox("Confirm deletion from " & [TRADE].[Enter a specific start date (dd/mm/yyyy)] & " ?",1)=2

However it doesnt work properly, it shows cannot find "TRADE"

I have no form in this database. What can I do? Thanks!

[MMcCarthy]

Dear all,

I have a delete query for users to delete a specific period of data. the SQL of the query is:

DELETE [TRADE].[TRADE_DATE]
FROM TRADE
WHERE ((([TRADE].[TRADE_DATE]) Between [Enter a specific start date (dd/mm/yyyy)] And [Enter a specific end date (dd/mm/yyyy)]));


And I want to use macro to display a msgbox to let user to confirm the date he has entered, I create the condition of CancelEvent like this:

MsgBox("Confirm deletion from " & [TRADE].[Enter a specific start date (dd/mm/yyyy)] & " ?",1)=2

However it doesnt work properly, it shows cannot find "TRADE"

I have no form in this database. What can I do? Thanks!

The delete query is used to delete a complete record not just a value in one column. You will need to use an update query.