need to check a field for previous record in form

[clemdawg]

Hi,

I have a form based on a table; in the table there is a Yes/No field that I use as a flag to know whether the data was updated. I have 'next record' and 'previous record' command buttons on the form. I want to be able to add code to the 'next record' button that will look at the Yes/No field (flag) for the PREVIOUS record to see if it is set to yes, ie updated and if not, I want a message to pop up saying the previous record was not updated..... I'm not sure how to do that.....

Thanks!

[June7]

Very tricky.

Try:

Me.RecordsetClone.Bookmark = Me.Bookmark
If Not Me.RecordsetClone.BOF Then
Me.RecordsetClone.MovePrevious
If Me.RecordsetClone![fieldname] = False Then MsgBox "Not updated"
End If