Access 2000 query parameters (or variables?)
Posted on 2003-03-08
In Access 2000 I have a list box for which the data source is “select . . . from Q”
Q is a query which looks like “select . . . from (Q1 left join Q2 on . . . ) left join Q3 on . . . “
Q2 has a where clause which includes a form variable comparison :
Q3 has a where clause which includes a form variable comparison :
The list box in question is also on form F0022.
My list box works fine.
However, if I create another instance of the form with
“set frm2 as new Form_F0022”
my list box query in frm2 behaves according to the control values in the original F0022.
How can I code the query parameters to pick up the contextually appropriate values (i.e.: those in the form where the list box resides)?