Clunietp,

Is there anyway we can pass the field from combo1 list to MyFieldNameToSearch.

ex. instead of
SELECT TestTable.* From TestTable where MyFieldNameToSearch = '" & text1.Text & "' order BY..

MyfieldNameToSearch is pass on by combo text?

Just wondering...