I have a form from which a user is able to select four values, from which I build a SQL.

The intent is to present a report using the parameters choosen by the user.

I have the process of creating the string working fine, but the result is a text string such as SqlTxt = 'Select All From MyData Where Color = "Orange"'.

My question is what is the best way to invoke that SQL statenent, i.e. make it run.

Thanks.