Subforms and Query Parameter

[luminairesolutions]

I'm using Access 2007 and attempting to build a series of forms. As most of them will the same set of search criteria, I would like consolidate them to 1 form and use it as a sub form.



For example,
I have two forms frmParameters that contains combo-boxes, list boxes etc. One of the main forms, frmCapitalLaborReport, would have its own parameters and include frmParameters as a subform.

frmParameters uses a query qryGetCalendarPeriods to populate a listbox based on a change in the combo-box. frmParameters is completely independent of any other form.

When I test just frmParameters, both combo-box and list-box are populated. When I embed frmParameters in frmCapitalLaborReport, the query is unable to locate the combo box for its parameter.




Would appreciate your opinions/ideas

[pbaldy]

I don't have 2007 on this machine, but it sounds like you need to adjust the form reference due to the form becoming a subform:

Forms Refer to Form and Subform properties and controls

[luminairesolutions]

I purposefully didn't want to refer to frmParameters as a subform in my query as I hope to reuse it in multiple forms (similar to frmCapitalLaborReport).

I worked it out by removing the reference to the form name from my query and using QueryDefs to load the listbox. The Query has a parameter and I pass the ID of the selected Combo box item in the Change Event Handler. I'll update my sample and post shortly.