[AccessD] Next, Prev

Actually, I may be able to work this out if I can add a sequential number to 
each record in my name-sorted query.

Can anyone remind me how to do that?


----- Original Message ----- 
From: "Kath Pelletti" <kp at sdsonline.net>
To: "Access D Normal List" <accessd at databaseadvisors.com>
Sent: Friday, September 05, 2008 10:51 AM
Subject: [AccessD] Next, Prev


> Must be the week for working on Next, Prev functions on the 
> list............
>
> This is a bit of an odd situation, but what I have a continuous form which 
> displays names and ID's. It's source is a query which is sorted by the 
> Name field.
>
> In another area of the application, I need to be able to know the ID of 
> the 'next' rec in that continuous form.
>
> eg. Continuous form shows:
> Name                 ID
> AAB                    90312
> AAC                    23
> AAD                    845
> AAE                     32
>
> If I have a form for AAB open, I need to get the ID of the next item AAC, 
> which is 23.
>
> Maybe I am making this too hard, but the fact that the list is 
> alphabetically sorted has me thrown...............
>
> tia
> Kath
>
> ______________________________________
> Kath Pelletti
> Software Design and Solutions Pty Ltd
> kp at sdsonline.net
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>