How query mode works – PB Docs 2017

Once the DataWindow is in query mode, users can specify selection
criteria using query by example — just as you do when you use Quick
Select to define a data source. When criteria have been defined, they
are added to the WHERE clause of the SELECT statement the next time data
is retrieved.

The following three figures show what happens when query mode is
used.

First, data is retrieved into the DataWindow. There are 36
rows:

Next, query mode is turned on. The retrieved data disappears and
users are presented with empty rows where they can specify selection
criteria. Here the user wants to retrieve rows where Quarter = Q1 and
Units > 15:

Next, Retrieve is called and query mode is turned off. The
DataWindow control adds the criteria to the SELECT statement, retrieves
the three rows that meet the criteria, and displays them to the
user:

You can turn query mode back on, allow the user to revise the
selection criteria, and retrieve again.