Albert Larry Lustig writes about this issue often and suggests NOT using a region but a List box to show the existing rows. Put two buttons next to the list box, one for INSERTing a new row and another for EDITing the highlighted row. Each brings up a different form to enter the missing data. If the new row is supposed to have values copied from a previous row, the user could click on that row in the list box, click on INSERT and your code could pre-load a row with all values to be copied. After the row is editing, you can refresh the list box and the row will be in the right position.
David David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "Albert Berry" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Saturday, March 12, 2005 3:14 PM Subject: [RBG7-L] - Scrolling region order when adding new row > We are enhancing a manufacturing data set to allow one or more operations for each part, and one > or more sub operations for each part + operation combination. As we are updating over 1,000 parts > with one or more operations, the user needs to assign the sub operations from scratch. > > I have created a form with the linking table which contains four columns: an abitrary integer PK, > autonumbered, that I really don't care about, the part (text 12), the operation (integer) and the > sub-operation (integer). The user goes into the form by specifying a wild card for the part > number. He could specify "23" and every part starting with the characters "23" will appear. The > table will be ordered by the part and the operation. > > The table has been pre-loaded with all combinations of part and operation, with a single instance > of the combination. The sub operation is null. > > My problem is that when the user adds a second sub operation, the new row is at the very bottom of > the region. This is very, very inconvenient for the user. I have tried: > > PROPERTY TABLE <tablename> "REFRESH" > NEXTTAB > PREVTAB > RETURN > > on an eep on saving the row, but this does not return the user to the row with the null sub > operation that he just added, which is what we want. > > We want to be able to [+] for a new row, and have that row display immediately below the row the > user was on when he clicked the [+]. Any ideas? > > > > Albert Berry > Management Consultant > RR2 - 1252 Ponderosa Drive > Sparwood BC, V0B 2G2 > Canada > (250) 425-5806 > (250) 425-7259 > (708) 575-3952 (fax) > [EMAIL PROTECTED] > >
