L
LDV
I am using the RunCommand SaveRecord in a macro and it appears to work just
fine in some cases and not at all in others. This is a multi-user
enviornment. About half the time users run this macro it works without
incident, but the other times it will not save the record. The form that the
macro is activated has record locks set to edited record.
The command is line 15 of a 21 line macro, so you'd think something else may
be causing this, but all other lines in the macro appear to work just fine
except one other. When the RunCommand SaveRecord does not work the last line
of the macro OpenForm also does not work. But the 4 OpenQuery lines in
between the RunCommand and OpenForm lines seem to work jsut fine. If the
lines were producing an error wouldn't I get a pop-up screen saying the macro
halted? It does not do that.
The only other point of interest is that the RunCommand and Open Form lines
both follow a SetWarnings line.
I'm stumped? Any suggestions. The user is getting this error, but I cannot
duplicate on my machine so stepping through it doesn't do me much good.
Thanks
fine in some cases and not at all in others. This is a multi-user
enviornment. About half the time users run this macro it works without
incident, but the other times it will not save the record. The form that the
macro is activated has record locks set to edited record.
The command is line 15 of a 21 line macro, so you'd think something else may
be causing this, but all other lines in the macro appear to work just fine
except one other. When the RunCommand SaveRecord does not work the last line
of the macro OpenForm also does not work. But the 4 OpenQuery lines in
between the RunCommand and OpenForm lines seem to work jsut fine. If the
lines were producing an error wouldn't I get a pop-up screen saying the macro
halted? It does not do that.
The only other point of interest is that the RunCommand and Open Form lines
both follow a SetWarnings line.
I'm stumped? Any suggestions. The user is getting this error, but I cannot
duplicate on my machine so stepping through it doesn't do me much good.
Thanks