First Record

M

Mike Johnson

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
 
M

Mike Johnson

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
 
Top