bob,
Thanks for the VBA code update. I have one question when looking at the code since i am relatively new to programming in VBA. It appears to me as if you ar assigning the results from the query that you generated within the combo box - is the "me" referencing the query that is generated...