Access 2007 Macro irregular results using control on click

[Bill]

I just installed Microsoft 2007 Access, and transferred a 2000 file to 2007
using import functions to create a new file. I have an update macro attached
to a label (executed on click) that uses go to records and setvalue features
(among others), and an imbedded macro. When I execute the macro by clicking
the label, the macro executes and goes through all the steps, but the results
are incorrect. However, when I execute the macro using the run macro function
from the ribbon, the results are correct.
I have tried recreating the macro, using different controls, and even the
button feature to execute this macro, and still get inaccurate results, yet
the run macro function from the ribbon is consistently accurate.
Can anyone tell me what's going on and how to correct this?

 

[Steve Schapel]

Bill,

Can you please give the details of the macro, and also what is meant by "the
results are incorrect"? Maybe a specific example would help.

--
Steve Schapel, Microsoft Access MVP

I just installed Microsoft 2007 Access, and transferred a 2000 file to
2007
using import functions to create a new file. I have an update macro
attached
to a label (executed on click) that uses go to records and setvalue
features
(among others), and an imbedded macro. When I execute the macro by
clicking
the label, the macro executes and goes through all the steps, but the
results
are incorrect. However, when I execute the macro using the run macro
function
from the ribbon, the results are correct.
I have tried recreating the macro, using different controls, and even the
button feature to execute this macro, and still get inaccurate results,
yet
the run macro function from the ribbon is consistently accurate.
Can anyone tell me what's going on and how to correct this?

__________ Information from ESET Smart Security, version of virus signature database 4181 (20090623) __________

The message was checked by ESET Smart Security.

http://www.eset.com