Hello,
I'm new to Access and inherited someone's database.
While doing some tinkering, I clicked the search button on a form
and tried tracing the code in debug mode.
The search button's code immediately calls another form with:
However, once this line executes, two functions in a module namedCode:DoCmd.OpenForm "Form2", acNormal
mod_querydefs are executed before control goes to Form2 code.
I don't understand what calls these functions and why they are executed
before Form2 code. If I comment one of them out, I get run-time error 3085
"Undefined Function function X in Expression". This is strange.
And if I do a stack trace while I'm in one of the functions, I get this:
functionX()
<non-basic code>
Frm1_Btn_click()
I'm not sure if "non-Basic code" is hidden code which is calling these functions.
All I can say is that this is pretty damn confusing.