Solved

Microsoft Access form help with sorting

Posted on 2014-01-21
3
376 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

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…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

757 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

20 Experts available now in Live!

Get 1:1 Help Now