First line of datasheet view is new record

[bhrosey via AccessMonster.com]

In a subform, in datasheet view, is there a way to make the first line the
new record instead of the bottom line?

 

[Guest]

No

You can simulate this though by placing a single line form just above the
datasheet and then use this to add new records.

__________________________________________

It my be an idea not to use a public non-denominational forum for religious
graffiti ?

I thought a long time before posting this but I feel strongly that this is
not the place for this type of text.

 

[Guest]

I do not know what procedure you are using to add a new record but add event
to requery and have it sort ascending on a field that always contains data
when record is complete. A new record will have a null and will sort at the
top.

 

[UpRider]

If the newly created record contains an autonumber ID, you can make it
appear 'first' by sorting the recordsource for the subform on the ID DESC.
That will put the highest number first.

UpRider

 

[bhrosey via AccessMonster.com]

Thanks for the feedback Wayne and I apologize if I offended you or anyone
else in any way, but the so-called graffiti you speak of, is simply a
reminder for myself and others of the saving grace of Jesus Christ. You're
right, Wayne, this is a public forum, so I am free to use this as my
signature if I choose.

Thanks again for the datasheet help, it's much appreciated.

God Bless,
Bill R.

 

[bhrosey via AccessMonster.com]

But will that make the "New Record" line be at the top of the datasheet or
will it still be at the bottom until I create the new record? I just don't
want them to have to scroll down through a bunch of lines to get to the new
record line.

Thanks!
God Bless,

Bill R.

 

[UpRider]

Bill, Ahhh I see the object you are trying to achieve now. I have no
suggestion for getting the new record line away from the bottom....
UpRider

 

[Guest]

If that is all then teach them to click on the navigation element that is a
right arrowhead with asterisk.

 

[Bob Quintal]

If that is all then teach them to click on the navigation element
that is a right arrowhead with asterisk.

Better yet, put a big button on the mainform that says "ADD RECORD" and
takes the user there.

 

[bhrosey via AccessMonster.com]

Thanks for all the help, it is very much appreciated!!!

God Bless,

Bill R.