Entering New Record on Subform

[Jon M.]

Hello all,
I have a form with a subform in Datasheet view as usual. Is it possible to
set up my subform so that my new, or blank record, is displayed at the top of
the subform as opposed to the bottom of it?

Basically I have my subform coming from a query, my query sorts my records
in descending order so the most recent records are at the top of the list.
If I could make it so that the new record is automatically at the top of the
list as it's being entered that would be a huge help to my users.

As always I appreciate any suggestions. Thanks.

 

[John W. Vinson]

Hello all,
I have a form with a subform in Datasheet view as usual. Is it possible to
set up my subform so that my new, or blank record, is displayed at the top of
the subform as opposed to the bottom of it?

Only by some rather finicky trickery. You can use TWO subforms: one with
AllowEdits True, AllowAdditions False to display existing records, and another
with DataEntry set to True for adding new records. Position the addition
subform carefully above the main subform and you can get at least the
appearance of one subform in the position you desire.