Put blank record at top of form

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

I created a continuous form, but I want the blank record for data entry
to appear at the top of the list of records rather than the bottom of
the list. Is there a way to get it to move to the top of the list? I
tried sorting the list on the Id field but that did not work.
 
This is asked pretty often. Do a search and read the previous post.

The short answer is "No".

You can add fields in the main form and have code that inserts the data into
a new record, but you can't put the actual 'new record' at the top.
 
Just checking,,,,,,,,,,,I can just put a button to add a new record so
staff don't have to scroll to the bottom of the form.
 
To help you along when you google as Rick suggested ---
You can do it two ways:
1. Put unbound fields directly above your continuous form to give the
appearance that the new record is at the top. You then need code using
RST.AddNew and Rst.Update to add the data from the unbound fields to your
recordsource. And while you are at it, set the AllowAdditions for the
continuous form to False. Then set it to True before the Rst.AddNew and back
to False after the Rst.Update. This eliminates the new record from sight
making the unbound fields look more like the new record.
2. Place a one-field subform based on the same record source as your
continuous form above the continuous form. This is more direct. You can do
the AllowAdditions thing here too.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

If you don't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
 
PC Datasheet said:
If you don't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
Click to expand...

These 1000 (if at all a real figure..) is only the result of
-- 4 years abusing the newsgroups.
-- 4 years blatantly advertising and jobhunting.

You just don't care about the newsgroups. You have no ethics at all.
You only care about making money, and you act as if the groups are your private hunting ground.

-- You abuse this group and others for job-hunting and advertising over and over again
-- You are insulting lots of people here when they ask you to stop this
-- You posted as Steve, Ron, Tom, Rachel, Kathy, Kristine, Heather and ??? while asking questions
(the latest 'star's': 'Access Resource' and Tom (e-mail address removed))
-- You try to sell a CD ($125,--) with FREE code you gathered from these groups here
-- There even has been a 'Scam-alert' about you which has been explained recently in the thread 'To all':
http://groups.google.com/group/comp.databases.ms-access/msg/46038ba2954261f9?hl=en
-- Also recently it became clear that you have been spamming innocent people asking questions:
http://groups.google.com/group/comp.databases.ms-access/msg/4f76d0ed3e5f58ad?hl=en

So why would ANYBODY ever trust a person like you and hire you?
********************************************************

To all: Explanation and more on this answer to Steve:
http://home.tiscali.nl/arracom/stopsteve.html

Arno R
 
You could use code something like this somewhere in the main form:

DoCmd.GoToControl "SubformControlName"
DoCmd.GoToRecord , , acNewRec

The could be associated with a command button, or the form's Current event,
or whatever works for you. This doesn't put the new record at the top, but
it puts the user immediately at the new record.

..
 
Back
Top