First and Last record check?

T

Tony

How can I write a code to check if the current record is
first or last record.

Thank you in advance,
Tony
 
M

Marshall Barton

Tony said:
How can I write a code to check if the current record is
first or last record.
Click to expand...


If Me.CurrentRecord = 1 Then
'First record
ElseIf Me.CurrentRecord = Me.recordsetClone.RecordCount Then
'Last record
Else
'not first or last
End

If you do not get the right number for RecordCount, then add
a Me.RecordsetClone.MoveLast to the form's Load event.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merge Excel file into Word Document 3
Copy previous record into form field 0
Improving Macro That Keeps First Letter 0
Grouping Names in Mail Merge 0
Adding data to MS Access from csv file 0
Duplicate Mail Merge Record Every Time 5
Word isn't capitalizing the first word of each sentence 2
Merging from an Excel file with graphics 1

Top