datasheet

  • Thread starter Thread starter chrisl
  • Start date Start date
C

chrisl

Hello,

Is there a way that the order of records can be reversed
in a datasheet subform along with the new record cursor
position?

For instance, we need the last record entered in the
datasheet to show up at the top going down to the first
record entered, additionally, the new record cursor needs
to be at the very top so users do not have to scroll all
the way down to see the current record.

Any help is appreciated.

Regards,
Christi
 
You can make the RecordSource for your subform a query that contains an
ORDER BY clause sorting the appropriate field in descending order.

The location of the New Record line in tables and continuous form subforms
is "by design", meaning it cannot be changed. One work-around is to set the
AllowAdditions property of your subform containing records to "No". Then
use a second subform, with the DataEntry property set to "Yes", to add new
records only. Position this second subform directly above the first
subform. Another possible solution is to use the Command Button wizard to
create record operation/navigation buttons on your subform, one of which
could be an "Add" button which will immediately position the user's cursor
in a new record, eliminating the need to scroll.
 
Back
Top