Access 2007 Macro irregular results using control on click

B

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

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


Bill said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top