How Can I Tell What a Form is Running in the Background?

[txdave35]

Hey guys,

I have an Access 2003 database designed 10 years ago by a consulting firm. The database contains a form where you select the fiscal year and hit an update button.

I need to understand exactly what the form is doing behind the scenes. There are several queries and macros that are being used. I need to find out the order that these queries are being run when I hit this update button.

How can I find this out? If I look at the properties of the Update button, I don't see anything that references the queries. Can anyone point me in the right direction? Thanks!

 

[HarleyQuinn]

Look at the Event tab of the properties window for the button and look for On Click. There should be either [Event Procedure] or the name of a macro in your DB. Then click on the elipses (...) next to that to see what's going on.

Hope this helps

HarleyQuinn
---------------------------------
Carter, hand me my thinking grenades!

You can hang outside in the sun all day tossing a ball around, or you can sit at your computer and do something that matters. - Eric Cartman

Get the most out of Tek-Tips, read FAQ222-2244: How to get the best answers before posting.

http://lessthandot.com

 

[missinglinq]

I'm trying to figure out how a database was developed 10 years ago in a version of Access only released 6 years ago! ;0)>

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[TheAceMan1]

How are ya txdave35 . . .

Follow the code in the [blue]UpDate[/blue] button.

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[ProgramError]

Step through it using a break point and the F8 key

Ian Mayor (UK)
Program Error
9 times out of 10 I know what I'm talking about. This must be my tenth reply.