MS Access VBA Cycle through records

[Viradis]

I'm trying to cycle through all records in a Access database. I want to find a value of a field in a column. Based on that value I need to update another field. I've been trying to get a FOR loop to go through each recordset, but I’m having no luck.

[MAK]

Try to avoid looping. Looping is too expensive.

looping example:

http://users.bigpond.net.au/abrowne1/ser-29.html

http://www.experts-exchange.com/Data..._20641510.html

BTW. Why cant you use "update" statement with different conditions.

[twinman326]

Vir:
Why don't you use an "Update query"

UPDATE "Table_Name"
Set"Colum_1"=[New Colum]
WHERE{conditions}

[twinman326]

Vir:
Why don't you use an "Update query"

UPDATE "Table_Name"
Set"Colum_1"=[New Colum]
WHERE{conditions}

[Viradis]

Thanks for the help the update query worked great.

[twinman326]

Viradis:

Your welcome..Anytime.Anymore problems, I will be glad to help...