Continuous Form - New Record at Top?

[JudyJones]

Can a subform which is a continuous form be created so that the location for a new record is at the top instead of the bottom?

[mbarron]

I don't believe you can have the first new record appear at the top.

What you could do is has two sub forms. One being a data entry single line form and the second being your continuous form.

The attached shows what I mean. Once you enter the data in the data entry form, the continuous form is refreshed, placing your most recent record at the top of the list The data is sorted by the ID - descending)

[JohnH]

I have been using a solution similar to the one suggested by mbarron, and I have found it very popular with users.

NewAtTop.gif

[JudyJones]

Thanks to both of you for offering this solution. We will try it and see if it works for us.