By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,688 Members | 1,233 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,688 IT Pros & Developers. It's quick & easy.

I want to show last five records in subform

P: 7
Dear Sirs,

I tried your valuable commands (below mentioned) but I got last record.

Private Sub Form_Current()
Dim rs As Recordset
Set rs = [Form_pjobcard subform].Form.RecordsetClone
If rs.RecordCount Then
rs.MoveLast
[Form_pjobcard subform].Form.Bookmark = rs.Bookmark
End If
rs.Close
Set rs = Nothing
End Sub

Sir, I want to show last five records, Please assist me

Premdas
Oct 23 '07 #1
Share this Question
Share on Google+
1 Reply


FishVal
Expert 2.5K+
P: 2,653
Do you have any criteria to consider records to be last?
Maybe Autonumber field or datestamp field.
Oct 23 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.