I wanted to limit what shows up in the query based on the value of another column.
That other column only has 2 valid values so I ended up creating two queries and put a different fixed Key Prefix in each.
I read the value of the other column when the query cell gets focus and place the name of the appropriate query in a string variable.
The Preset Value/Expression for the query cell is just equal to the string variable.
I'm surprised that there isn't some easy way to pass an argument to the query. Maybe in Celltag$? I would think that this comes up fairly often.
That other column only has 2 valid values so I ended up creating two queries and put a different fixed Key Prefix in each.
I read the value of the other column when the query cell gets focus and place the name of the appropriate query in a string variable.
The Preset Value/Expression for the query cell is just equal to the string variable.
I'm surprised that there isn't some easy way to pass an argument to the query. Maybe in Celltag$? I would think that this comes up fairly often.