[AccessD] Next, Prev

Susan Harkins ssharkins at gmail.com
Fri Sep 5 07:50:30 CDT 2008


And it can be slow if you're dealing with a lot of data.

Susan H.

> I guess you could and should use DMin without any issues:
>
> NextItemID = DMin("ID","qryMyFormQuery","[Name] > '" & [Name] & "'")
>
> It will sort "correctly", that is the default sorting of your database. If 
> you need any other sorting the plot thickens.




More information about the AccessD mailing list