?
Solved

Microsoft Access form help with sorting

Posted on 2014-01-21
3
Medium Priority
?
392 Views
Last Modified: 2014-01-22
On a continuous form is it possible to have the "new" record at the top of the form instead of the bottom.
textbox.jpg
0
Comment
Question by:J.R. Sitman
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 48

Accepted Solution

by:
Dale Fye earned 800 total points
ID: 39798704
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
 
LVL 38

Assisted Solution

by:PatHartman
PatHartman earned 800 total points
ID: 39798713
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
 

Author Comment

by:J.R. Sitman
ID: 39799813
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

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Suggested Courses

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question