Continuous Forms Loop (1 Viewer)

[IanT]

Hi

Have been trying to find a solution with-out success!

I have a Continuous Form, I need to check the value of a particular field for each record that appears on the form. Obviously the code I have at the moment only looks at the first record.

Can anyone help!!!

 

[Travis]

Using ADODB and the Forms Recordsetclone

Dim rst As Object
Set rst = Me.RecordsetClone
Do While Not rst.EOF
    'Check Field
    rst.Fields("{FieldName}").Value
    rst.MoveNext
Loop
Set rst = Nothing