Resetting Values in Records

[Anne]

What's the best way to reset a yes/no field back to "no"
for a group of records? I tried a For, Next statement,
but it will not reset the value - say's "object doesn't
support this property or method".

Thanks for any suggestions.

 

[Phobos]

An UPDATE query?

P

 

[JohnV]

Anne,

I use loops to go through code and then update a yes/no
field. The line below is a recordset that I opend. As I
do some imports I mark a field (Imported) to Yes so that I
can determine what information has been imported.

rst!Imported = True

JohnV