Changing Data Using VB

  • Thread starter jdtyler via AccessMonster.com
  • Start date
J

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
 
T

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?
Click to expand...

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
 
Top