Getting the next record (VBA)

[Rodolfo Fontes]

Hi group,

How can I get the next value of a querie?
For example, I can use "temp = rs_NFS!DT_Emissao" to get the DT_Emissao from
the current record, but i want just to get the next value, not "walk" on it.
Below an example:

Dim db_NFS As Database, rs_NFS As Recordset
Set db_NFS = CurrentDb
Set rs_NFS = dbs_produtpenRecordset("SELECT [T NF_S].DT_Emissao, [T
NF_S_Det].CodProd, [T NF_S_Det].Qtd_NF, [T NF_S_Det].Valor_NF " _
& " FROM [T NF_S] INNER JOIN [T NF_S_Det] ON [T NF_S].Cod_NF_S = [T
NF_S_Det].Cod_NF_S " _
& " WHERE ((([T NF_S].DT_Emissao) Is Not Null) And (([T
NF_S].Processada) = -1) And (([T NF_S].Cancelada) = 0)) " _
& " ORDER BY [T NF_S].DT_Emissao, [T NF_S_Det].CodProd;")

Thanks,
Rodolfo Fontes