Unanswered: Use a dynamic global variable for query condition
I have a form frmPackages which has 10 choices. making a selection and clicking Next moves onto to the next form. The next form 'frmCustomise' has a list box with values specific to each package derived from a query, currently what I am doing is placing a small textbox on the form somewhere and when the selection is made, the code places the criteria for the query in the textbox and the query uses the text in the textbox as criteria. This saves me having to create 10 forms with 10 queries. But this is a crap way to do this? What I have toyed with in the past is assigning a value to a global variable and have the query use this value as criteria. Can anyone help me with this or suggest a better way?