Go To Blank Record in Form

[mous]

Hello There

Can anyone please tell me if when I'm in a form entering data say, in the first two records I exit out of the form and when I return I would like the cursor to jump to a control of my choice on the next blank record.

I cannot do the method AcNewRecord as I have predefined records for example, my form/table is set out this way:

No Subject Date

7001 My Subject 05/08/02
7002 My Next Subject 05/08/02
7003
7004
7005
7006
7007

How do I say next time I enter this form the cursor should point me at the subject field on record 7003.

Many Thanks

 

[Tim K.]

Use FindNext. I assume both fields are null.

Private Sub Form_Load()
Me.RecordsetClone.FindFirst "Isnull([Subject]) And Isnull([Date])"
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub

 

[mous]

Brilliant. Thank you.