Subform - New Record Question

[griswom]

Ok, I have a quick question..
I have a continuous Notes subform which displays all notes for a given policy. Currently the notes subform sorts the records from Newest to Oldest descending. This is great, but what I really want is for a New Note Record to be the first note on the continuous form, and then the existing notes to follow in the order described above. Can this be accomplished? Thanks in advance.

Griz

 

[jplum]

You might be able to accomplish your goal using two subforms instead of just one.

One of the subforms could be a continuous form, but read only. This way you would not get the line for a new record here.

The other subform could be shown as a single form and it could be just shown to add a new record. This way you should only see the line for a new record here. This subform could be above the other subform.

I have never tried this, but it might work.

Jennifer