Using a Public Variable in criteria of a Query

[swenger]

I have a Public Variable called Prd which I confirmed has a value since I created a button which simply on event is msgbox {variable} and when I click on the button the correct value shows.

I have a query which I would like to use the Variable as the criteria, however when i type the variable Prd in the criteria for that column it encloses it in [Prd] but when I run the query I still get a pop up to enter a value for [Prd]

What is the fix for this?



Thanks
Sam

[swenger]

So I found on Microsoft site that you can't use a variable in a criteria of a query so I followed their solution to create a Function which calls this variable and use the Function in the criteria.

This worked.

Thanks