I have a form with several text lists designed to filter data in a hierarchical way based on selections in the text lists.
Text List 1 gets its data with a formula. It will never be empty.
Text List 2 gets its data with a query based on the selection of Text List 1. It could be empty.
Text List 3 gets its data with a query based on the selection of Text List 3. If Text List 2 is empty, it shows “Field or Variable [var] is undefined”.
Any way to improve this GUI to eliminate that message? Thank you.