Access Form Question - The Underlying Queries and Calculations

[cmcfarland]

Hello and Greetings from a true MS Access neophyte!

I work in MS SQL all the time, and am enjoying my first foray into the MS Access world.

I've got a SQL table linked to Access successfully, and they use some Forms to access data that has formerly been in an Access table, but now will involve data that'll be pulled from my linked SQL table.

What I need to do is get to the part of these forms where I can see the queries that are used to drive the work that the form does.

I can go into the Design part of the form, and I was hoping to find the underlying statements that drive the different buttons.

Man was I disappointed to find that this info wasn't right there in the Design view of the form!

I've poked around, but do not see where to find that.

I'll need to modify whatever drives the buttons so that they look in the right places and deliver the results that I'm after.

Might be missing something really simple.



So, thanks for taking a look and I'm really looking forward to seeing what you all think!

[June7]

The RecordSource property on the Properties Sheet data tab binds form to table or query.

Events can use macro or VBA code. Select the button and look at the Properties Sheet Event tab. If event property shows [Event Procedure] then it is using VBA code and click the ellipsis (...) to open VBA procedure.