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.