List/Matrix Form shows All Records instead of Selected


#1

Used the Construct menu to create a List/Matrix Form. Selected a subset (52 of 142 visible)… but ALL records are still showing in the form. What am I missing here?


#2

In the Text List Options in the Query box, type: info(“visible”)

Otherwise, you get everything.


#3

Thanks! That did the trick.


#4

To explain a bit further, Text List objects are designed to have their own searching, independent of whatever selection has been performed in the data sheet. By using the info(“visible”) function, you are telling the Text List object to use the same search criteria that the data sheet is using. This page explains how to set up independent searches in a Text List object.