Hi, I am new to this forum but trying it out. Currently I work with Access 2000 and have a database set up with a combo list box to select all the materials in my table. What my situation is, there are two categories I would like to be able to select by clicking on a button in the option box which in turn filter out only those records. There has to be an easy way besides doing the manual toolbar filters because the end users at the company are not the cool with databases. How can I write code to make the option button selection only reveal the one category I want to see at any given time, and then how to make it also select All records when needed? A rather long message but not sure how I was to explain it. Really hope someone can help me out. Self taught here and learning pretty well....intermediate I suppose.