Cycle Through records

[WireGuy]

I have a form that contains from 1 to many records, I would like to perform a
validation comparing the quoted price to the cost price. (One Quote can
contain many parts)

I'm thinking it would look something like

Sub

Dim r

r = rows count

If quoted price < cost value then
msgbox " Change Quote"
Exit Sub
End if

Next r
End Sub

This is far from correct but I hope to get some assistance in creating this
validation step before sending through to generate the Access report (actual
quote)

Thanks!
Wireguy