[AccessD] frmMain.Bookmark = rs.Bookmark...too slow!

Hi Christopher

Not that I know of. However, I don't find it that slow if the field(s)
you search on is/are indexed.

/gustav

>>> clh at christopherhawkins.com 13-01-2005 00:27:22 >>>


Is there a faster way to do the "jump straight to a selected record"
thing?  Usually I use code like this:

        Set rs = Forms("frmMain").RecordsetClone
        rs.FindFirst "RecID = " & Me.RecID  

        Forms("frmMain").Bookmark = rs.Bookmark

But in many Access DBs this is very slow.  Is there a faster way to do
the same thing?

And yes, I know the best way to ensure a fast database is to design it
right.  I don't always have the luxury of rebuilding the rickety systems
I find myself working on.  ;)

-Christopher-