----- Original Message ----- From: "Lawrence Lustig" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, November 04, 2004 4: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. Ok. Got it. Actually Filter by itself (if it is exposed as a Property) will allow the navigation on the Recordset that is established by the original Where Clause without the Closing and Reopening of the Form. > -- > Larry >
