Distinct Query AbsolutePosition [Solved]

When creating a Distinct recordset the AbsolutePosition property is all messed up.

I Am using DAO on A Access Database.

Does anyone know how to correct it.

Hi,

Can you put down your logic/Code of creating the distinct recordset ? So that I can help you.


Gs

set rst = dbs.openrecordset("Select Dintinct Field1 From table1")
msgbox rst.absoluteposition

Figured out the problem.

In A distinct recordset you can set a bookmark to a old bookmark without getting a error. So it never reloaded the new recordset

By the way ADO is better than DAO

True.

But for access databases dao is much quicker.