Hi all,
I've dug into this a fair bit already and not found anything that worked, including an almost identical situation. I have a form with subform (Screenshot attached) inside a tabbed control. The subform draws from a junction table relating components to assemblies. I wanted a button for each record in the subform that will, when clicked, open the form which contains information about the components at the record for the component in question. When I use the control wizard and it asks which fields to match I get the field list for the form I want to open, but the field list for the current subform is blank. I've tried, using the expression editor, to add a 'where' clause to match the field from the subform to the destination form but to no avail.
The argument for that piece looks like this: frmMaterials, Form, , [Forms]![frmMaterials]![PartID]=[Forms]![frmAssemblies]![subfrmBOM].[Form]![PartID], , Normal
I'm not sure if it matters but the destination form has, in the header, a combobox set up as a search box.
Any thoughts on how to make it work?