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. SitmanIT DirectorAsked:
Who is Participating?
 
Dale FyeCommented:
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
 
PatHartmanCommented:
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. SitmanIT DirectorAuthor 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.