How do I get the "new Record" to the top?

[JH]

I have a continuous form that I sort in reverse date order - ie today at the
top of the form. I would like to get the "blank" record that access provides
for a new record to the top as well so that the user can enter new data at
the top of the form. Any clues how todo this?

John

 

[Allen Browne]

You cannot do that with a bound continuous form.

 

[hj]

Hi JH,
I don't think there's a way to display a blank new
record at the "top" of a display of existing forms.
However, there are a couple of strategies to think about
here.
If you simply want the user to be able to get to a
blank form quickly and the navigation button for "new
record" is not displayed, you can add a command button to
the form header which will take the user immediately to a
new record (blank) form. You can set the button's Display
When property to "Screen Only" so that it won't print out.
If you want the form to open to a blank (I don't think
this is what you want), you can set the form's Data Entry
property to Yes. This will open the form view to a new
record but not allow browsing the existing records.

Hope this helps.

 

[Craig Alexander Morrison]

As others have said you can not do this, however...

You can make it look like you can by having two sub-forms which are
essentially the same form, the lower one is for the display of existing
records and on this you can allow edit and additions or not, depending upon
your preference.

The one located above this should look similar if not almost identical and
this one is in data entry mode, so it will be blank waiting for a new
record.

To make it look more "wired-up" you can run requeries to display the most
recently entered record at the top of the lower sub-form and clear the top
sub-form ready for a new record.