Data Entree question

[Rose]

In using a datasheet view subform is it possible for the blank line to enter
data to appear on the top of the datasheet rather then the bottom. This
would help in data entree when multiple records exist to stop scrolling all
the way down to enter new records. Thanks

 

[Eric Blitzer]

You could use 2 subforms. One above the other. The top on is for entering
new records and the bottom one shows existing records. After adding new
record refresh forms.

 

[Al Campagna]

In using a datasheet view subform is it possible for the blank line to enter
data to appear on the top of the datasheet rather then the bottom. This
would help in data entree when multiple records exist to stop scrolling all
the way down to enter new records. Thanks

 

[Al Campagna]

Rose,
Not in datasheet view.
However, you can make a continuous subform that looks just like a datasheet view.
A common technique to accomplish what you want, is two subforms. The first one would
be one record high, and with DataEntry set to YES, would only allow new records to be
enetered.
The second subform would be a normal continous(*) subform that only displays previously
entered records (Add New set to NO)
By removing Headers from Sub2, and Navigation buttons, it would be possible to make
these two subs look just like one subform... with new records added at the top.

 

[Rose]

Thank You
--
Rose

Rose,
Not in datasheet view.
However, you can make a continuous subform that looks just like a datasheet view.
A common technique to accomplish what you want, is two subforms. The first one would
be one record high, and with DataEntry set to YES, would only allow new records to be
enetered.
The second subform would be a normal continous(*) subform that only displays previously
entered records (Add New set to NO)
By removing Headers from Sub2, and Navigation buttons, it would be possible to make
these two subs look just like one subform... with new records added at the top.
--------------------------------------------------------------
Subform1 - New records only
---------------------------------------------------------------
Subform2 - AddNew = NO
.
.
.
.
.

----------------------------------------------------------------

(*)This might be do-able in datasheet, but I've never tried it. I think 2 datasheet
subs will not be able to look "exactly" like one subform. Continuous forms are much more
"customizable. Wouldn't hurt to give datasheets a try though...

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."