Loop

[Guest]

Good afternoon,

I have a continuous form. How can I loop thropugh each record and perform
certain action?

Thank you,

Daniel

 

[Marshall Barton]

I have a continuous form. How can I loop thropugh each record and perform
certain action?

Consider that request carefully. Most everyone that asked
for that is seriously violating the rules of normalization
and trying to treat with the recordset as if it were a
spreadsheet.

If you have a really valid reason for doing this. the code
would be along these lines:

With Me.RecordsetClone
If .RecordCount > 0 Then
.MoveFirst
Do Until .EOF
'perform unspecified action
Loop
End If
End With

 

[Tim Ferguson]

I have a continuous form. How can I loop thropugh each record and
perform certain action?

Use a query on the underlying recordset:

UPDATE MyProducts

SET CurrentPrice = 1.15 * CurrentPrice,
LastIncrease = DATE()

WHERE YEAR(LastIncrease)<2006;

Hope that helps


Tim F