Moving the New Record in a Continuous Form

[Mara O'Neill]

I have a continuous form which is sorted in descending order. Is it
possible for the 'New Record' to be the first record of the form instead of
the last?

Mara

 

[Cheryl Fischer]

Do you mean that you want the empty row into which a new record is entered
moved to the top? If so, no, that capability is not available.

One possible work-around is to have a main form with two subforms on it.
One subform would contain your continuous form with all data showing. The
other subform, positioned immediately above it, would use the same record
source as the other subform, but with its Data Entry property set to 'Yes'.

 

[Mara O'Neill]

Yeah, that's what I meant. I suspected such. Thanks for the two subform
suggestion.

Mara