Can I change the way that a record is placed in a subform?

[Ani_unicorn]

I want to change the order that entries are listed. ie the new row appears
beneath the last entry, I want the new row to be at the top so that the
latest entry is always at the top of my records.
Is this possible? Please let me know how if it is?
Thanks
Ani

 

[John Vinson]

I want to change the order that entries are listed. ie the new row appears
beneath the last entry, I want the new row to be at the top so that the
latest entry is always at the top of my records.
Is this possible? Please let me know how if it is?

It can be done, though it's a bit tedious to set up.

What you will need to do is use TWO subforms - one just for the "new
record", and a second to display existing records, one above the
other.

Set both forms to Continuous form default view, and line up the
controls identically (so they look as if it were one form to the
user).

The upper form should be just tall enough to display one record; its
DataEntry property should be True, AllowAdditions True.

The lower form should have AllowAdditions False (so you won't see a
new-record line at the bottom), AllowEdits True (assuming you want to
be able to edit existing records). You'll need to requery this second
subform in the AfterUpdate event of the first.

John W. Vinson[MVP]

 

[ani_unicorn]

Thanks John
I will have a go!
Cheers
Ani

It can be done, though it's a bit tedious to set up.

What you will need to do is use TWO subforms - one just for the "new
record", and a second to display existing records, one above the
other.

Set both forms to Continuous form default view, and line up the
controls identically (so they look as if it were one form to the
user).

The upper form should be just tall enough to display one record; its
DataEntry property should be True, AllowAdditions True.

The lower form should have AllowAdditions False (so you won't see a
new-record line at the bottom), AllowEdits True (assuming you want to
be able to edit existing records). You'll need to requery this second
subform in the AfterUpdate event of the first.

John W. Vinson[MVP]