> 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
