Looping thru a table problem

M

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.
 
S

Steve Schapel

Marguerite,

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

Marguerite Hall

Thanks. That worked.

Steve Schapel said:
Marguerite,

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