can't trace function call

[visions]

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:

DoCmd.OpenForm "Form2", acNormal

However, once this line executes, two functions in a module named
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.

[pbaldy]

See if they are called from a query the form being opened is based on.

[visions]

thanks pbaldy. how would I do that?

[pbaldy]

Either look through the fields in design view or SQL view. What is the record source of the form?

[June7]

What is the form RecordSource - table, query, SQL statement? If it is query or SQL statement the functions could be called by expressions.

I use Rick Fisher's Find and Replace add-in to track down issues like this. Saved my sanity more than once. Cost about $50.

[visions]

thanks guys. sorry for the late response. between work, opposite time zones, and connectivity issues its hard to respond.
anyway, I checked the form record source and it was a query. That takes care of one of the functions being called, but that query doesn't contain any calls to the second function. I'm hopeful I'll figure it out.

[pbaldy]

Does the query reference another query? Can you post the db here?

[visions]

I don't think it references another query, but i'll try to post it tomorrow (it's bed time where I'm at).
appreciate your help.

[visions]

I will probably get in trouble if i post the database, but perhaps I can post a form if needed.
As I mentioned earlier, the record source property caused that form to be dependent on a query.
However, there is another query which this form depends on, and I can't trace it. I tried the "build event" option when I right
click on the form in design mode, but I saw nothing there.

I verified the dependencies using the dependency tool in Access.

Access's design is ticking me off.

[visions]

Also, the first query does not reference another query.

[visions]

I'll try to get Rick Fisher's tool...
This dependency issue is a huge flaw of Access.

[pbaldy]

I've heard good things about a free utility called V Tools and it has a deep search tool.

[visions]

ok i'll check it out

[Missinglinq]

What, if any code, is in the Form_Open and Form_Load events?

In Form Design View, if you go to Properties - Data is anything listed in the Filter or OrderBy properties?

All of these will execute before you 'see' the Form.

Linq ;0)>

[visions]

What, if any code, is in the <strong>Form_Open </strong>and <strong>Form_Load</strong> events?<br>
<br>
In <strong>Form Design View</strong>, if you go to <strong>Properties - Data</strong> is anything listed in the <strong>Filter</strong> or <strong>OrderBy</strong> properties?<br>
<br>
All of these will execute before you 'see' the <strong>Form</strong>.<br>
<br>
Linq <strong>;0)&gt;</strong>

<br>
<br>
The Form_Load event does not contain the query in question, further the query executes before Form_Load executes...<br><br>I check Properties-Data, and nothing is there.<br><br>Perhaps I shouldn't dwell too much on this because the execution of that query apparently doesn't have any negative effects.<br><br>Appreciate the help.<br><br>