Microsoft Access form help with sorting

On a continuous form is it possible to have the "new" record at the top of the form instead of the bottom.
textbox.jpg
J.R. SitmanAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Dale FyeConnect With a Mentor Commented:
No, but you could set the Allow Additions property to false and get rid of that row altogether.

You really should do all of your data entry through forms anyway.  I usually include an "add record" button somewhere on my continuous form which pops up another form for entering individual data, then when you save that data, it requeries the continuous form (if you sort it right, this new record will be at the top) and sets the focus to the record that was just created.
0
 
PatHartmanConnect With a Mentor Commented:
No.  People solve this problem by adding unbound controls to the parent form and then inserting the new record using DAO or an append query.

You could try using two subforms.  The first one (on top) would be set to DataEntry = Yes and the second would be set to AllowAdditions = No.  I haven't tried this but give it a whirl.  It might solve your problem.
0
 
J.R. SitmanAuthor Commented:
both answers came in at almost the same time so I'm splitting points.  Thanks for helping.  I'm not going to make any changes.  Just needed to know if it was possible.
0
All Courses

From novice to tech pro — start learning today.