Christopher Hawkins
clh at christopherhawkins.com
Wed Jan 12 17:27:22 CST 2005
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-