First Record

G

Guest

How would you go about determining if the current record on the form is the
firstrecord?
 
O

OfficeDev18 via AccessMonster.com

Mike said:
How would you go about determining if the current record on the form is the
firstrecord?
If Me.CurrentRecord = 1 Then....
 
J

Joerg Ackermann

Mike Johnson:
How would you go about determining if the current record on the form
is the firstrecord?

Private Sub Form_Current()
If Me.Recordset.AbsolutePosition = 0 Then
MsgBox "This is the first record"
End If
End Sub

Acki
 
G

Guest

Thanks.

Joerg Ackermann said:
Mike Johnson:


Private Sub Form_Current()
If Me.Recordset.AbsolutePosition = 0 Then
MsgBox "This is the first record"
End If
End Sub

Acki
 

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

Top