Subform sort/data entry

[Ray]

I have a subform with multiple records displayed from a single table. It is
sorted descending on "year" and has only one record per year. New data is
added in this subform once each year.

Is it possible to have the "new" data entry line appear at the top rather
than at the bottom?

Thanks in advance for any help.

 

[Rick Brandt]

I have a subform with multiple records displayed from a single table. It is
sorted descending on "year" and has only one record per year. New data is
added in this subform once each year.

Is it possible to have the "new" data entry line appear at the top rather
than at the bottom?

No, but you can simulate it by using two subforms. One that is set to DataEntry
mode (new records only) and one that has AllowAdditions = No which suppresses
the display of the new(*) record row at the bottom. Formatted and positioned
just right you could achieve what looks very much like a single form with the
new record position at the top.

 

[Van T. Dinh]

Sorry, no. There is a work-around but it is very messy and not worth it.