I have designed out a nice access 2003 database in which i have multiple forms and tables. I have one form in particular based on a table with a few hundred results.
One of the fields on the form is a lookup box with about 5 options to select from which we will say are option A - Option E.
The form in question also contains sub forms which may complicate things a little.
I have now placed an option group on the form and i want people to be able to select "All Records", "Option A only", "Option B only" etc etc
How can i filter the results based on this option box.
I have searched and searched the net and come up with all sorts of ideas but am not succeeding in finding an accurate result.
Anyone any ideas???