Creating Pages Out Of An Sql Report

[Deltaflyer]

Creating Pages Out Of An Sql Report

I am running a complex SQL command that is pulling back 2000+ records with 35 fields, but only want to be showing apr. 30-50 records per page. (With hyperlinks for the other pages)

Trying to initialize RecordSet.AbsolutePage=1 always returns the error :

ADODB.Recordset error '800a0cb3'
Object or provider is not capable of performing requested operation.

When i have checked RecordSet.AbsolutePage it is storing a value of -1

Can anyone tell me how to initialize this string so that i can get my page working.

Thanks, Deltaflyer
[sig][/sig]