recordsets question

[Psycho_NZ]

hello,

in ADO, can u use on recordset as a basis for a select statement on another one.

for example, if you have rstNames with a bunch of names, could u create a rstA and use rstNames to obtain all the names starting with A from rstNames?

Thanks for your time
Ang

[barek2001]

You don't have to create another recordset just to obtain a resultset that has a name starting from 'A'. All you have to do is to pass a query the filters your previous recordset --'rstNames'-- to display all names starting from 'A'.

Try this code:

rstNames.Open "Select * from [table name] where name like 'A%',cn,adLockReadOnly,adCmdText

[Psycho_NZ]

ok ta

[Swatty]

You could also filter your recordset.

rstNames.Filter = "name like 'A%'"

After the use of it you can reset the filter by

rstNames.Filter = ""