Hi all, I am working on an application that involves database access and I am trying to incorporate a querying mechanism using controls. Like, I get my SQL query built in the following fashion form a dialog

SELECT (parameter1 form combo box) from tablename WHERE something BETWEEN (parameter2 from Edit box1) AND (parameter3 from Edit box2);

Now I got this to execute properly by writing some ugly code using the pointer to the recordset (m_pSet), but I am sure it is not a good way. Is there a simpler and better way to execute this kind of a thing without too many manipulations?