How to Edit the Macro that exists behind an existing Command Butto

Hi There,

Hoping someone can help me out ...

I have inherited the task of managing an Access 2007 application.

Within this application I have an Access 2007 form that has a Command
Button. I'm not sure how this Command Button was created (Macro, Query,
etc.) but I do know what it does. I would like to edit the Query/Macro this
Command Button executes. I'd rather not edit the VBA coding as I am a VBA
Beginner.

Can you pleae let me know how I can edit the Command Button's Query/Macro.

Thank you,

Jason

A command button can run a macro or a VB event procedure. If it runs an event
procedure, you cannot modify it via a macro.
Go into design view on the form, right click the button and choose 'build
event'.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"TP9999" wrote:

Hi There,

Hoping someone can help me out ...

I have inherited the task of managing an Access 2007 application.

Within this application I have an Access 2007 form that has a Command
Button. I'm not sure how this Command Button was created (Macro, Query,
etc.) but I do know what it does. I would like to edit the Query/Macro this
Command Button executes. I'd rather not edit the VBA coding as I am a VBA
Beginner.

Can you pleae let me know how I can edit the Command Button's Query/Macro.

Thank you,

Jason

Hi Dorian,

Thanks for the info. After analyzing the code it states that it opens a
Form. Can you suggest a good Access 2007 book that teaches all aspects of
Access 2007 in a clea, ordered, and concise manner. And includes VBA coding
for Access 2007.

Thanks,

Jason

"Dorian" wrote:

A command button can run a macro or a VB event procedure. If it runs an event
procedure, you cannot modify it via a macro.
Go into design view on the form, right click the button and choose 'build
event'.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"TP9999" wrote:

Hi There,

Hoping someone can help me out ...

I have inherited the task of managing an Access 2007 application.

Within this application I have an Access 2007 form that has a Command
Button. I'm not sure how this Command Button was created (Macro, Query,
etc.) but I do know what it does. I would like to edit the Query/Macro this
Command Button executes. I'd rather not edit the VBA coding as I am a VBA
Beginner.

Can you pleae let me know how I can edit the Command Button's Query/Macro.

Thank you,

Jason