subform - new record

[Guest]

how can i get the empty record to be first in a subform rather than the last
record? in other words, i'd like the user to tab from the main form to the
empty record in the subform without having to scroll through a bunch of
records.

thanks in advance

(i know this has probably been answered elsewhere but i sure can't find it
anywhere)

 

[Rick Brandt]

how can i get the empty record to be first in a subform rather than
the last record? in other words, i'd like the user to tab from the
main form to the empty record in the subform without having to scroll
through a bunch of records.

thanks in advance

(i know this has probably been answered elsewhere but i sure can't
find it anywhere)

Can't. You can simulate with two subforms. One set to data entry mode and the
other with AllowAdditions set to No. If you Requery both after every insertion
it will give you close behavior to having the new row at the top.

 

[Larry Daugherty]

Look in Help for GoToRecord. In the form's Load event put in a line
to go to a new record.,

Actually, if you just open the code to the Load event and enter
Docmd.gotorecord Intellisense will help you the rest of the way.

HTH

 

[Guest]

wow, you guys are fast. i'll try your suggestion, larry. sure beats "can't"
which i don't think my client will be too happy about but, hey, that's his
problem. thanks.

 

[Rick Brandt]

wow, you guys are fast. i'll try your suggestion, larry. sure beats
"can't" which i don't think my client will be too happy about but,
hey, that's his problem. thanks.

Just to clarify. Larry's suggestion will take the user to the new record row,
but it will still be at the bottom, not "first" as you asked for. That is what
I said "can't" be done without using two subforms.

 

[Guest]

thanks rick. i understand what you're saying. i'll try larry's suggestion and
see if that doesn't help. some of my client's clients contain dozens of
entries in the subform so i can understand his desire to have the new record
at the top of the form.