Access 2007 Macro irregular results using control on click

's Computer Specifications

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 Computer Specifications

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" <(E-Mail Removed)> wrote in message
news:5A5C694E-5C4A-4DE5-BFEC-(E-Mail Removed)...
> 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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Access 2007 - double click to resize control is broken?	UsenetUser	Microsoft Access Forms	0	28th May 2009 02:09 AM
Irregular Queries Results	=?Utf-8?B?QXJ0aHVyUw==?=	Microsoft Access Queries	3	7th Sep 2006 07:40 PM
Simple Interest with irregular expenditures, irregular reimbursements at irregular intervals	Frank B Denman	Microsoft Excel Worksheet Functions	2	17th Sep 2004 06:14 AM
Re: right click on cmd btn or macro btn, but no dialog box to assign control?	Ron de Bruin	Microsoft Excel Misc	0	14th Aug 2003 06:36 PM
right click on cmd btn or macro btn, but no dialog box to assign control?	Ian Elliott	Microsoft Excel Misc	0	14th Aug 2003 05:54 PM