Filtering Delete Query

[edgarchado]

Hi to all,
I need to create a command button which will let me filter a delete query?

In other words, I need to have a button that when clicked will ask me for the delete criteria of the delete query.

In my case I have an orders table and i want, through a delete query, decide which order to delete by informing the order number.

Thanks in advance

 

[BNPMike]

If your delete query is run from a command button then add a where criterion into the delete query eg [Please enter the order number to be deleted].

Personally I would have thought it would be better to select the order from a form or drop-down and use that value in your delete query. Otherwise your users will make more errors.

 

[edgarchado]

BNPMike,

Thanks for your answer. It is a very good idea using a form. How would you do it?

Thanks.