I've been looking for a bit, but haven't found a good answer. I've found that I could generate the code in a VBA procedure and run it from there, however, i'm working on someone else's design and don't want to change it up too much.
In part of that pass-through query we have something like this:
WHERE (((ID='380')
I want the 380 to be code that will look at a UserForm combo box, write a query for my database returning a value WHERE column = combobox.value
I hope that makes sense, let me know if anyone know's how to work with this. Thanks.
After looking around a lot and researching a bit it seemed that only a stored procedure on the server (Which I cannot do) or creating a string and passing that string to the pass-through query are my options. I'm going to pursue the string option since it seems like the best option with my constraints here. if anyone comes up with any idea's later on that would help, let me know. Thanks.