Subform rows

[PJ Usher]

Access 2000

1. Form A has Subform B associated
2. Subform B is defined as a continuous form, the unique id is hidden
3. Subform B has
Row 1
Row 2
Row 3 . . .

Is there a way to insert a row between Row 2 and Row 3?

Thank for any help.

PJ

 

[Larry Linson]

You can insert between Rows 1 and 2 only if you have a field on which you
sort, and enter the value for that field between the values for Row 1 and
Row 2. At that, you may have to Requery to get it properly in order... by
default, all records are added at the end of the existing data, but they are
displayed in the order you sort them in a query or otherwise. If you don't
sort them, then the order in which they are displayed is officially
unpredictable.

Larry Linson
Microsoft Access MVP