How about this:
- base the form on a dummy table
- add the real table to edit into the form as a slave
- use an on-after-start eep containing a loop with PROPERTY TABLE tablename NEXT or PRIOR commands to position to the desired row
- use the same or PREVROW/NEXTROW commands to reposition as desired
The only thing missing would be the ability in an eep to jump to a relative or absolute position, as one can with a scroll cursor. But if you write eep code using the PROPERTY TABLE tablename NEXT/PRIOR/FIRST/LAST commands to do the repositioning to a desired record, it should execute without displaying each and every row in the process.
In this approach it would be useful to have:
PROPERTY TABLE tablename REL n
PROPERTY TABLE tablename ABS n> 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
Emmitt Dove Manager, DairyPak Business Systems Blue Ridge Paper Products, Inc. 40 Lindeman Drive Trumbull, CT 06611 (203) 673-2231 [EMAIL PROTECTED] [EMAIL PROTECTED]
