Passing Parameters to an ODBC

[J]

Hi,

I am writing a report in XL2007 which has a user form to capture the
criteria required to query an SQL database.

Question, how do I pass the users selected options from the controls to the
ODBC because there is no longer an option (that I can find) that lets you
refresh the ODBC from cell values in XL as you could in XL2003 - I used to
set the cell values from the user form! Is there a way to pass these values
direct to the ODBC parameters?

Any help or pointers would be greatly appreciated.

Tia