B
BWD
Spinning my wheels here....
I have one table with 1,000+ records and each record has a (required)
status; active or inactive. These records are stored in one table
called customers. I have a form that displays the customers and would
like to add a combo box to my form so that I can filter which records
are displayed.
The intended result would be a combo box that displays 2 values;
active and inactive. When one of those values is selected from the
combo box the forms recordset would only contain records that have the
status chosen from the combo box. For example, the user selects
"Active" from the cmbo box, only records with an active status are
available to scroll though on the form.
I have tried docmd.applyfilter and me.filter methods with results that
do not match what I am hoping for. Do I need to write a
clonerecordset command into my VBA or...?
Thanks
I have one table with 1,000+ records and each record has a (required)
status; active or inactive. These records are stored in one table
called customers. I have a form that displays the customers and would
like to add a combo box to my form so that I can filter which records
are displayed.
The intended result would be a combo box that displays 2 values;
active and inactive. When one of those values is selected from the
combo box the forms recordset would only contain records that have the
status chosen from the combo box. For example, the user selects
"Active" from the cmbo box, only records with an active status are
available to scroll though on the form.
I have tried docmd.applyfilter and me.filter methods with results that
do not match what I am hoping for. Do I need to write a
clonerecordset command into my VBA or...?
Thanks