Changing Data Using VB

[jdtyler via AccessMonster.com]

Hi there,

I need a script to change the data in one field within a table for every
record.

So I can do 'Me.FieldName = "Yes"' to change the current record but can't
seem to get it to do this for all records within the table.

Is this possible?

Thanks

 

[Tom Lake]

I need a script to change the data in one field within a table for every

record.

So I can do 'Me.FieldName = "Yes"' to change the current record but can't
seem to get it to do this for all records within the table.

Is this possible?

Why not just use an Update Query? If you're intent on using code, you'll
have to loop through each record in the file, possibly using MoveNext, and
update the field in question. Yes, it's do-able.

Tom Lake