Refering to Opened ADO Recordset as Datasource

M

Max

Hi, i am having table of Customers having 30000 records, Table Structure like
this

Month-Customer-Name
2007/01-X
2007/01-Y
2007/01-Z
2007/02-X ..... and so on

I am using ADO, using "Select * from tbl Where Customer Name like
<condition>" i am creating recordset. Now i want to use this opend recordset
as datasource and create a new recordset which will return me the "Distinct
Month Value" for the selected Customer name. I want to fill this Distict
Month value to fill combo box.

Thanx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top