Hello,
I have a form that has both list boxes and a subform table pointed at a standalone table. Unique records (ie.PipeMaterial) are displayed in the subform table and common records (ie. ProjectName) are in the List boxes with the row source as "Select Distinct". I want to be able to edit/enable/make visible a text box if the corresponding List box is empty but I am unable to figure out the coding to allow for this.
I am unsure if I am unable to code the text box due to the "Select Distinct" portion of the List Box.