Hi All
I have a problem that has been driving me mad that I hope someone can help with.
I have a basic form based on a table. In the form I have an unbound combo box that displays a list of activities (taken from a list in a table). When you select an activity and then click on a button it filters the records for all of those about that activity (there are two filter buttons, one for activities that haven't been done and one for those that have which is a simple yes/no tick box in the record). The buttons run a basic macro to ApplyFilter.
This all works fine. The problem comes when you then change the activity showing in the unbound combo box and try to filter for a new activity instead (even when you have clearer the previous filter). Clicking on either button to ApplyFilter applies the filter referencing the first activity that was selected and filtered on rather than the one currently selected. The only way I've found to get round this is to close and reopen the form, but I don't want to have to keep on telling the rest of my team that this is what they need to do.
Any thoughts on this very much appreciated.
Thanks