Quote Originally Posted by OBP
...
The Syntax is critical though as VBA SQL is very unforgiving.
The whole process has been unforgiving. 2 weeks ago I had only ever used Access databases with peoples user-friendly forms and output. Now I'm designing one from scratch.

As of right now I've temporarily abandoned the form until I get get my data filtering setup.

I've created a table called 'SearchValues' that I want to pass to my 'MadIDQuery' and 'ExchangeIDQuery'. 'SearchValues' has 'ExchangeID' and 'MadNumber' in it and now I just need to link those up and I might actually be close to finishing this nightmare....probably not.