Hello,
I have a form with a combobox that selects records.
Is there a way to filter the combobox based on the form filter?
For example:
My form holds a recordset of 100 records, and without any filter applied, my combobox also holds 100 choices......
I want my combobox to reflect the curent recordset even when filtered, so if i use the filter by selection on a field which might narrow the recordset down to 10 records, i then want my combobox to only have those 10 records instead of the non-filtered full amount of 100 records.
Sorry if this is confusing! Hopefully someone out there understands what i am trying to do and can help!
Thanks,
Brian
I have a form with a combobox that selects records.
Is there a way to filter the combobox based on the form filter?
For example:
My form holds a recordset of 100 records, and without any filter applied, my combobox also holds 100 choices......
I want my combobox to reflect the curent recordset even when filtered, so if i use the filter by selection on a field which might narrow the recordset down to 10 records, i then want my combobox to only have those 10 records instead of the non-filtered full amount of 100 records.
Sorry if this is confusing! Hopefully someone out there understands what i am trying to do and can help!
Thanks,
Brian