How do I get new records to add to top of continuous form

[Guest]

I can get the display order to list records from most recent date to earliest
date. But you have to scroll all the way to the end of the list to add a new
record. How do I get new records to insert at the top of the list?

 

[Rick Brandt]

I can get the display order to list records from most recent date to
earliest date. But you have to scroll all the way to the end of the
list to add a new record. How do I get new records to insert at the
top of the list?

You can't. You can use a subform or unbound TextBoxes at the top and then
do the insertion in the background.

 

[John Vinson]

I can get the display order to list records from most recent date to earliest
date. But you have to scroll all the way to the end of the list to add a new
record. How do I get new records to insert at the top of the list?

You can't, not the way you describe.

One way to get this APPEARANCE is a bit of work but doable. Use TWO
continuous Subforms: one of them with its Data Entry property set to
True, Allow Deletes and Allow Edits False, set to be just one line
high; immediately beneath it put a second subform based on the same
table/query with Allow Additions set to False, Allow Edits True. That
way you can enter data in the first subform (only new records) and
display existing data in the second. With careful control of position
it can *look* like just one form with the new record line on top.

You'll need to Requery the second subform in the AfterUpdate event of
the first.

John W. Vinson[MVP]