Easy question, but I'm brain dead - looping through records

[tweaked2005]

So I'm trying to apply the following conditional code to each record in the dataset that is loading in my form. I know I need to loop through each record, but I can't remember the code necessary to do so (is it something like recordset.EOF). Any help on looping through records is greatly appreciated! Thanks!

Private Sub Form_Open(Cancel As Integer)
If today - Me!startDate < 45 Then newComment = "Too New"
End Sub

 

[Remou]

I think you would be better off adding the code to a textbox, rather than updating a field with data that will be out-of-date tomorrow.