Set Focus on formload?

[Sniper-BoOyA-]

Good Morning,

I am currently using the SetFocus event to generate a number

Private Sub WetDensity_GotFocus()
mycounter = Nz(DMax("mycounter", "tblverdgrdnucleair")) + 1
End Sub

as an alternative to the Autonumbering option.

But, when i use this on a continious form, i have to SetFocus on every record.

Is it possible to go through all the records (WetDensity) on the FormLoad event, so the user doesnt have to click/tab his way through the form to get the numbering going?

 

[vbaInet]

Is there any reason why you didn't want to put your code in the Default Value property of the control?