Access 2007 Buttons and identifying SQL code

[Adam]

Hi all,

Can someone help me find out how to identify what SQL commands are linked to a button on a form?

I'm trying to find the SQL/Query linked to a button in a Access 2007 dB.

Thanks,

Adam

[rajan verma]

Do you want to get it by code .. ?

Rajan

--
Forum Rules:
1) Use concise, accurate thread titles. Don't use Poor thread titles, like Please Help, Urgent, Need Help, Query Problem, Need Advice will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Acknowledge the responses you receive, good or bad.
4) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited.
NOTE : Don't ever share your personal and confidential data . Forum owners and members are not responsible for any loss.
 
Group Email ID : acces...@googlegroups.com
Send Mail to Unsubscribe : access-sql+...@googlegroups.com
More Details about Group : http://groups.google.com/group/access-sql?hl=en

--
Regards
Rajan verma
+91 9158998701

[Adam Stratas]

I'd like to see the code linked to a button.

[rajan verma]

if i am correct, you can see the Event Assign to the button by Right Click on the button , goto property of button. there are some event listed in the property explorer , you can find the associated event there 

Rajan,

[Adam Stratas]

Once I locate the event, how to do I find the associated query/macro linked to the event?

[BrianDP]

It'll spell it out in the code... Something pretty obvious like:

 

docmd.openquery "THE NAME OF THE QUERY IS HERE!"

 

or something like that.

 

 

-BrianDP