Opening a Form With Filtered Results And A Combo
Posted on 2011-04-26
I have a form (B) that is opened through a button on another form (A) that opens using a current record on form (A).
Once Form B is opened, it opens with filtered results. I have a combo box in form B that should usually change the data in the form according to what is chosen, but doesn't due to the filter.
The combo box is not the same data as the filter, but a subset of information within that filter. For example, if the filter was fruit, the the combo contains, apples, oranges, banana's etc.
I have tried putting criteria on the query that drives the combo box with something like Me.frmfruit.fruitID. Using this theory, I applied it in another form under the same scenario and that works perfectly. But this form, it doesn't work. Is that the right way of doing it? ie- Apply criteria in the combo box to tell it to use the current Fruit ID, but have a listing of all other fruits?