Put blank record at top of form

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.
 
R

Rick B

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.
 
R

Randy

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.
 
P

PC Datasheet

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
[email protected]
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.
 
B

BruceM

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.

..
 
J

jahoobob

Or, just open the form in add mode instead of edit mode. It opens in
the blank record ready user to add data.
 
Top