[AccessD] Next, Prev

Thx Stuart - and no, I haven't really used 'Name' as a field name - just 
trying to keep my message simple to the list.

kath
----- Original Message ----- 
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Friday, September 05, 2008 12:01 PM
Subject: Re: [AccessD] Next, Prev


> NextItemID =
> Dlookup("ID","qryMyFormQuery","[Name] > " & [Name])
>
>
> Incidentally, it's very bad practice to use "Name" as a field name - it 
> can bite you in all sorts
> of ways.
>
>
> On 5 Sep 2008 at 10:51, Kath Pelletti wrote:
>
>> 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
>
> -- 
> Stuart Mclachlan
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>