I am trying to use an option group to filter records on a form (frmItems). I have some code put together from various sources but can't get it to work. I would like to have the option group also filter the results of the "Quick Search" combobox on the form. Thank you in advance--your help would be greatly appreciated! HKL_Inventory-ver-4.accdb
1. You can't really filter the form records, if the combobox values will remain the same...
(The values in the combobox should reflect the values displayed in the form)
Meaning, ... your filter might exclude values displayed in the combobox...
If you filter the form for (lets say) USA, ....then you only want USA values in the combobox)
In other words, ...if you filter the form for a certain value, ...you must also provide a way to filter the combobox for that same value.
2. Your design is a bit confusing, ...I am not understanding the relationship between CountingUnitID and the option group values.
for example, ...what CountingUnitID represents New, Existing and All.
In your table, you only have CoutingUnitID values of One and Null
But the source for the combobox is 1 through 11
How do these values relate to: New, Existing and All.
...Or am I missing something?