Execute SQL statement against an existing Recordset

[Paul_Marlow]

Does anyone know if it is possible to execute an SQL statement against an existing recordset in order to create a sub Recordset???

If so, How???

Cheers

Paul

[JeffSM]

I don't understant your idea very well! you can test your record with the same WHERE if it return .EOF you use INSERT otherwise UPDATE.

jeff

[sRiram]

I don't think you can design a sub recordset all you can do is search the recordset with the seek command and if you reach the desired record populate a DBGrid or populate a temporary table which you can delete after somemtime.

[Big Dog]

Are you using SQL? Have you considered creating a view?

[bashfirst]

Use the Filter method on the first recordset to open the second one. See the example in the VB-DAO Reference for Filter.

Bash