SUBFORMREFRESH

This statement will requery the specified subform datasource.

SUBFORMREFRESH(Subform//SQL)

Parameters

Subform

            1 = Subform#1
            2 = Subform#2
            3 = Subform#3
            4 = Subform#4
            5 = Subform#5

SQL

            The SQL statement to populate the subform with.

EXAMPLE

To requery the 3rd subform with all customer names:

SUBFORMREFRESH(3//'SELECT name FROM tblCustomers")