New record entry at top of datasheet
Alan Yim
I have a form that is in Datasheet view and am wondering
if it is possible to have the new record entry appear at
the top of the sheet as opposed to the bottom.
Thanks,
Alan
Hugh O'Neill
says...
There's no way of changing this native behaviour but there is a work
round.
The way of doing this is to have two subforms. One is you present one
but with the Data Entry and Allow Additions properties set to No (if I
were doing this I might prefer to use continuous instead of datashheet).
The other is a normal view subform placed above that subform and made to
look as near as possiblike one of your rows. This subform should be set
for data entry only. In the after Update event of this entry subform,
Requery the one with the rows so it shows the new entry.
hth
Hugh
John Vinson
No. Training your users to look at the bottom is one possible option
<g>...
You can get this effect using two Subforms on an unbound main form,
one above the other. The top subform would be sized to show only one
row, and its DataEntry property would be True - this will let you
enter only new records, not view existing ones. The lower subform
would have AllowAdditions False, AllowEdits True to show records which
have been added. You will need one line of VBA code or macro to
Requery the second subform in the AfterUpdate event of the first.
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
Alan Yim
>.
>