Dynamic Criteria in a Query

[HeyYouYesYouNoNotYouYou]

Hi,

I am working on streamlining some of my database processes, one of these processes is stock control. I want to run a query where the criteria changes in a delete query based on what is entered in a form. This delete query is going to be used as part of the stock control process. The query identifies what to delete by the product ID number, however at the moment i have to manually enter this in the query, what i would like to do is to be able to populate the criteria box with the appropriate code directly from a form.

Thanks in advance

 

[Joe4]

Take a look here: Run a parameter query within an Access form - TechRepublic.

 

[HeyYouYesYouNoNotYouYou]

Thanks