Looping thru a table problem

[Marguerite Hall]

I've done this before...but for some reason am having a problem today. I
want to set a value in one field in every record in the table.

Set Value
New Record
Run Macro

I'm only looping 20 times and getting a message that a macro can only call
itself 20 times.

 

[Steve Schapel]

Marguerite,

It sounds like you should be using an Update Query, and an OpenQuery
action in the macro to run the update.

 

[Marguerite Hall]

Thanks. That worked.

Marguerite,

It sounds like you should be using an Update Query, and an OpenQuery
action in the macro to run the update.