Macro problems from command button

[Guest]

I'm experiencing a variety of problems getting macros to run predictably when
invoked from a command button. My previous post talked about SendKey
problems, but I have other problems also (SetValue). These macros work fine
when ran directly from the macro window, and also worked from command buttons
in Access 97. My latest question is: why does a macro behave differently in
Access 2003 when ran from a command button as opposed to running directly
from the macro window (and is there some way to get the macro to run the same
from a command button)?

 

[Guest]

UPDATE--I've experimented and am now where the macros will run correctly from
the command button the second time it is used (and thereafter; meaning going
back to the form and clicking the command button again). The macros will
always NOT work on the first try with the command button after launching
Access. They will always work on the first try from the macro window.

Again, these macros always worked with the command button under Access 97.