Solved

Microsoft Access form help with sorting

Posted on 2014-01-21
3
380 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:jrsitman
3 Comments
 
LVL 47

Accepted Solution

by:
Dale Fye (Access MVP) earned 200 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 34

Assisted Solution

by:PatHartman
PatHartman earned 200 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:jrsitman
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

920 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now