Query ask for Parameter on DoCMD.Close

[amcintosh]

Hi all

I got a menu form that contains a sub form which ultimately had another sub form within that sub form, which goes something like this

1. Menu form

2. Supplier Form header (SFrm_ExpirySummary)

3. Supplier details data table (SFrm_SupplierExpiry)

Form 3 get's it data from a query which contains a where statement that get's it data from a text box in form 2 (that is filled by a dropdown control in the same form)
Form 2 is simply ran as a sub form in Form 1

The Query it's trying to run is

SELECT Tble_GrowerDetails.SupplierCode, 
Tble_GrowerDetails.SupplierName, 
Tble_GrowerDetails.City, 
Tble_GrowerDetails.State, 
Tble_GrowerDetails.PostCode, 
Tble_QACerts.BaseScheme, 
Tble_QACerts.SchemeExpiry, 
Tble_TestResults.ProduceCat, 
Tble_TestResults.TestType, 
Tble_TestResults.TestExpiry

FROM ((Tble_GrowerDetails INNER JOIN Qry_Supp_ExpiryStatus ON Tble_GrowerDetails.SupplierCode = Qry_Supp_ExpiryStatus.SupplierCode) INNER JOIN Tble_QACerts ON Tble_GrowerDetails.SupplierCode = Tble_QACerts.SupplierCode) INNER JOIN Tble_TestResults ON Tble_GrowerDetails.SupplierCode = Tble_TestResults.SupplierCode

WHERE (((Qry_Supp_ExpiryStatus.Flag) Like [Forms]![Menu]![Frm_ExpirySummary]![txtCrit]))

GROUP BY Tble_GrowerDetails.SupplierCode, Tble_GrowerDetails.SupplierName, Tble_GrowerDetails.City, Tble_GrowerDetails.State, Tble_GrowerDetails.PostCode, Tble_QACerts.BaseScheme, Tble_QACerts.SchemeExpiry, Tble_TestResults.ProduceCat, Tble_TestResults.TestType, Tble_TestResults.TestExpiry;

Now I got a problem where if I try to close the menu form via a VBA or Macro it tries to evoke that query and asks for the parameter which ultimately crashes the database, this is despite that the button is simply close form and open an unrelated form

doesn't try to run it if I hit the X button though or if i simply minimize the Menu form

There is no macro/vba that I can identify that runs on load

Any idea?

[Micron]

Gremlins.
The only way (IMO) that anyone will be able to pinpoint this for you is if you copy, compact and zip the db and post it here. I'd say it's not the query, it's some code or macro step that you may not realize is executing.

[amcintosh]

Thanks Micron.

I've decided to just stick with the work around and minimize the form instead of trying to troubleshoot the issue at this point.

[mike60smart]

I would recommend resolving the issue before moving on as you will eventually need to return to this issue.

[Minty]

I suspect it to do with form unloading/loading orders.
In fact I'm surprised you don't get an issue on load, as the sub form(s) load first so form 3 may not be able to see form 2 properly on load.

I would try and fix it though.