Hi all, is there a way to have access start at the last record, or optimally, a new record when opening a form? I set the DataEntry value to on but that only shows the records entered from then on and that won't work because sometimes previous records need to be edited.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Start at end of records when opening a form 1
- Thread starter msuguy71
- Start date
-
1
- #2
missinglinq
Programmer
Hey msuguy71,
DoCmd.GoToRecord , , acNewRec will send you to a new record (assuming the form's property AllowAdditions is set to True). Put it in the Form Load sub.
Hope this helps.
The Missinglinq
"It's got to be the going,
not the getting there that's good!"
-Harry Chapin
DoCmd.GoToRecord , , acNewRec will send you to a new record (assuming the form's property AllowAdditions is set to True). Put it in the Form Load sub.
Hope this helps.
The Missinglinq
"It's got to be the going,
not the getting there that's good!"
-Harry Chapin
- Thread starter
- #3
- Status
