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!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Moving to last Record in Form's Record Source

Status
Not open for further replies.
monrosal

monrosal

Programmer
Aug 22, 2000
42
US
Does anybody know how I can move to the last record of a form's record source? After I click a command button, I change the form's record source to another query, but I want the record to display the last record of the query. Can anybody help?

Ramon
 
Sort by date Sort by votes
Private Sub Form_Open(Cancel As Integer)
Me.RecordsetClone.MoveLast
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub

Mike Rohde
rohdem@marshallengines.com
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

caykamanj1966
  • Locked
  • Question
Duplicate Records in DataSheet View
Replies
5
Views
424
Andrzejek
Andrzejek
I
  • Question
How to get 2 codes to work together.
Replies
6
Views
209
hermanlaksko
hermanlaksko
Kennelbloke
  • Locked
  • Solved
Subform not updating in parent form
Replies
10
Views
485
Kennelbloke
Kennelbloke
DB_Bowes
  • Locked
  • Question
Selection from Listbox to GoTo Record in Bound form Gives Error 2105
Replies
1
Views
180
DB_Bowes
DB_Bowes
TrekBiker
  • Locked
  • Question
This is the source query for what 1
Replies
12
Views
283
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top