Determining if user is in the first record of a continuous form

  • Thread starter Thread starter pubdude2003 via AccessMonster.com
  • Start date Start date
P

pubdude2003 via AccessMonster.com

Is there a simple way to determine if a user is in the first record of a
continuous form?

I want to vb a setfocus to a field in a mainform to move from the first
record in a continuous subform. Been looking for an hour now and just can't
seem to find a posting specific to this challenge.
 
Thanks guys, managed to mangle out some code based on a dMin of the
autonmumber field
 
Maybe you can use this bit of code. Its based on the "Duplicate Record X of
Y" example found of "The Access Web"
site(http://www.mvps.org/access/forms/index.html)



Private Sub Form_Current()
If Not Me.NewRecord Then
With Me.RecordsetClone
.Bookmark = Me.Bookmark
'MsgBox "Record " & .AbsolutePosition + 1

If .AbsolutePosition + 1 = 1 Then
' Put your code here and
'comment out/delete the next line
MsgBox "at record 1"

End If
End With
End If
End Sub

HTH
 
Back
Top