D
Dheinze57
I use the same form to display different sets of records from a query that
includes all records. I limit or filter for different subsets by using the
"Where Condition" in the "Openform" action in a macro.
On the form is a "List Box" which displays a list of all records from which
you can select a record by clicking the value in the "List Box".
How can I limit the "List Box" to reflect just the records in the current
subset of records. I beleive the statement or SQL will go in the "Row Source"
of the "List Box" properties.
includes all records. I limit or filter for different subsets by using the
"Where Condition" in the "Openform" action in a macro.
On the form is a "List Box" which displays a list of all records from which
you can select a record by clicking the value in the "List Box".
How can I limit the "List Box" to reflect just the records in the current
subset of records. I beleive the statement or SQL will go in the "Row Source"
of the "List Box" properties.