Global variables in a query (1 Viewer)

[iangirven]

i have a set of combo boxes that is currently used as a criteria in a query. This works fine.

What id like to do is assign the combo box data to a global variable that can be used at other points in the database.

is it possible to assign a global variable as a criteria so i can use the combo box data when the form it is on is closed?

I know i can assign the variable to a seperate table and use that data in the query. Also i could create a combo box from the form i want to run the query from. As the queries would be used on the same data this means i would have to duplicate the query as the criteria field would come from a seperate source and i really dont want to duplicate the qery.

hope ive been clear enough with this

ian

 

[Jack Cowley]

Give a quick search of the archives as this question has been dealt with a number of times....