problems for datasheet tabbing to next record

[dp]

Hope I can explain myself properly.

I have a datasheet with the last field as a combo box that "hides" when the
user tabs and it loses focus. When that field loses focus instead of tabbing
to the next record, it instead goes backward to the previous field. I have
checked the tab order and it is in proper sequence.

So I tried a work-around with code, which doesn't always move to the next
record if it is the first or last record (then moving to a new record)

Sub Rate_Item_LostFocus()

'**move to the next record
Dim rsCount As DAO.Recordset
Set rsCount = Me.Recordset
If Not rsCount.EOF Then
rsCount.MoveNext
Me.NameCbo.SetFocus
End If

End Sub.

Does anyone have any suggestions (non code/ code)?

Thanks,
David