----- Original Message ----- From: "Lawrence Lustig" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, November 04, 2004 3:15 PM Subject: [RBG7-L] - Re: Editing Prev/Next
> > > > EDIT USING master STARTING AT id_number = 132 ORDER BY id_number > > > > > > > > How is that different from EDIT USING master Where id_number >= 132 ORDER > > BY > > id_number > > Because (assuming id_number is fully populated), you would start at the 132nd > record in the dataset. You would be able to click Previous to go to ID 131, > previous again to go to 130, and so on. > > In your example, you can use NEXT to continue past 132, but not PREVIOUS to go > before it -- those records are not in the data set being used by the EDIT > command. > > In general, the ability to reposition the current record position from within a > form in a variety of "rich" ways would open a whole bunch of new user interface > possiblities. 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..... > -- > Larry >
