Perhaps thinking of it more like this will help: edit using... where RecNum between 10 and 20 starting at 15 order by RecNum
The form then opens of RecNum 15 and you can back as far as 10 and forward as far as 20. It would be wonderful for getting all the Sloops and starting on "John" but able to get to "Jon" and "John B" or "Jon B" easily as well. Regards, Alastair. ----- Original Message ----- From: "Lawrence Lustig" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, November 04, 2004 9:07 PM Subject: [RBG7-L] - Re: Editing Prev/Next > > So what you want is a Dynamic Sub-Select..... Limit your Record Source in > > the Where Clause, than by some other mechanism walk the Record Set based on a > > Sub-Select on the Record Set..... > > Well, I'm not sure I follow that, but what I believe is wanted is the ability > to reposition the form within the current record set without having to close > and open the form. Currently we can move to the first, last, next, and > previous records but if we want to move to some arbitrary record with an > arbitrary value we have to do that in code -- with a bunch of NEXTROW > statements that will refresh the form each time leading to furious blinking and > very poor performance (all EEPs would execute, etc). > > What would be really nice is if they could expose the underlying dataset FIND > and FILTER methods. Then we could "leap" directly to the record we wanted. > Navigation could then be controlled by a variable drop down box on the top of > the form, or by other mechanisms. > -- > Larry >
