NewRec@Top of datasheet view

[Anonymous]

The Question:

Is there a way to have an Access 2000 Continuous Form show new records at
the top of the list in the detail section? Is there a way to do it in any
other view?

The Problem:

In Continuous Forms view, default behaviour is to go to the 1st record in
the recordset - the oldest or youngest record - fine - shown at the top of
the detail section. Problem is, new records are at the bottom of the
section. I need the form to show new records at the top of the detail
section.

Info:

I have a Continuous form bound to a table. I have the Form Header and
Footer sized so that there are always 10 records showing when the form is
opened (the # of records showing is irrelevant - but it explains the
layout).

So, Form Header, details showing 10 records, then a Form Footer.

Form Header contains the bound controls the user uses to add/edit/delete
the records.

Details Section's controls are bound, but Enabled=No and Locked=Yes. The
Details section is just used to select a record to be edited with the Form
Header's controls.

If I sort the underlying table the right way, I get it to show the most
recent record at the top of the detail section. That's good. When I go to
add a new record, it jumps to the bottom of the details section, to the
oldest record. That's bad.

And finally, the Form Footer is currently blank but I will be adding
buttons later.

My users aren't exactly rocket-scientists, so I'm trying to make this as
easy for them as possible.

Thanks very much for any help anyone can provide.

Jeff

 

[Guest]

Why do you need to do this?
You can always position to the new record when you open the form.
Look in Access HELP for 'GOTORECORD'

-Dorian

 

[Anonymous]

This form is a subform. It is linked to its parent form, and when the
parent form changes, this form is requeried and the active record becomes
the one at the top of the list.

I can't set the OnCurrent to go to the most recent record, for obvious
reasons...

The user has to scroll to the bottom to get to the new-record row. That's
bad.

 

[Anonymous]

This is still unresolved if someone would like to take a stab at it...

 

[John Vinson]

This is still unresolved if someone would like to take a stab at it...

There is no way to put the "new record" at the top of a datasheet or
continuous form. IT IS IMPOSSIBLE within Access, as the program
exists.

What you can do, with a bit of extra work, is to use TWO continuous
subforms based on the same table. Make the upper one only one row
tall, and set its DataEntry property to TRUE so that it will be usable
only to enter new records.

The second subform should have the controls lined up exactly the same
way, same sizes and positions; its AllowAdditions property should be
False, AllowEdits True. This will display existing records and allow
them to be edited.

The only additional thing you'll need to do is to Requery the second
subform in the AfterUpdate event of the first.


John W. Vinson[MVP]

 

[Anonymous]

Hmm... looks like that may be the only way. It's already taking about 10
seconds to open the form and this is going to make it take longer, but
gotta do what'cha gotta do I guess.

Thanks for the help. I'll be trying that shortly.

Jeff