philfer
05-22-2010, 05:09 AM
Hello,
Has anyone been able to deploy comboboxes as filters on a form satisfactorily.
I have a form with several fields and am trying to use comboboxes as filter. The ControlSources for the comboboxes are the field from the table.
It is easy with one filter. I just set the filter and then filter on
When there are two filters it gets more difficult. I can filter the form by checking if the filter is empty and if it is setting it to the combobox selection and then turning the filter on and if it isnt empty setting the filter to the existing filter "AND" the new filter.
But I run into two problems :-
1) After the first filter I cant get the other comboboxes to only hold the values of the filtered dataset
2) If I then re-filter on the same field it gives no results as it is trying to look at the first filter "AND" the second one which gives a resulting empty dataset
Any ideas???
Cheers
Phil
Has anyone been able to deploy comboboxes as filters on a form satisfactorily.
I have a form with several fields and am trying to use comboboxes as filter. The ControlSources for the comboboxes are the field from the table.
It is easy with one filter. I just set the filter and then filter on
When there are two filters it gets more difficult. I can filter the form by checking if the filter is empty and if it is setting it to the combobox selection and then turning the filter on and if it isnt empty setting the filter to the existing filter "AND" the new filter.
But I run into two problems :-
1) After the first filter I cant get the other comboboxes to only hold the values of the filtered dataset
2) If I then re-filter on the same field it gives no results as it is trying to look at the first filter "AND" the second one which gives a resulting empty dataset
Any ideas???
Cheers
Phil