End of record set error

[mike wild]

When i press the page down key to cycle through the record set it often ends up past the last record, and i get an error 3314 about the id being set to true.

I have tried the following code on the forms "before update" and in the ID fields "before and after update" with no luck.

Private Sub Form_BeforeUpdate(Cancel As Integer)
If Me.ID = "" Then
DoCmd.GoToRecord , , acFirst
End If
End Sub

Where am i going wrong?? I must be something pretty simple iam missing?

 

[mike wild]

All fixed.

i just selected "no" to Allow Additions in the forms propities.

There are 200 records no more and no less. therefore it is ideal.