Moving between subforms...

B

Brett Davis

Okay here is the situation... :)

i have 2 subforms on a main form. what I am trying to accomplish is moving
from the first subform to the second subform on end of record set in the
first subform. Here is the weird thing... when I get to the last field in
the last record in the first subform the focus IS moved to the second
subform. When I say IS moved... the first field in the second subform is
highlighted like it has the focus but when you look closely... the cursor is
blinking in the first field in a new row on the first subform. Both
subforms are in datasheet views.

Here is the code I am running to determine the end of the recordset on the
last field called "Breed" on the Lost Focus event:
Dim RS As DAO.Recordset
Set RS = Me.RecordsetClone
RS.MoveLast
'MsgBox StrComp(Me.Bookmark, RS.Bookmark, 0)

If StrComp(Me.Bookmark, RS.Bookmark, 0) = 0 Then
Forms!frmMain!frmVisit!VisitDate.SetFocus
End If

I am running Access 2000.

Any would be great!

Cheers!

Brett
 
Top