Text List Queries

Panorama X
1

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.

2

When the database opens, you could use the .Initialize procedure to initialize any variables that are used by lists 2 and 3 to “”. They still won’t have any content, but they will be defined.

3

For any Text List that could reference an undefined variable, use the catcherror( function in the formula for the list, for example:

catcherror("",myQueryList)

Of course this will also work with Text Display objects, Image Display, anything. I use this constantly in Panorama X.