dropdown box for filtering form results

[chrisdedobb]

I am trying to make some sort of button that will allow me to filter the records being displayed on a form. I really like the idea of using a dropdown list (combo box) to do this.

I have 5 different users in this db. we use our names as a way to tell what records are ours. I want to be able to select my name from a dropdown list and have the form automatically filter the records to those that match my selection.

Is this even possible? If so, any help on how I would go about accomplishing this?

 

[Mike3411]

I'm pretty much an Access newbie, but I would start by manually adding a combo box to the form. The combo box wizard will pop up, allowing you to select "Find a record on my form based on the value I selected in my Combo box". This will let you specific a field to use as a filter. I've also done this by setting the data value of a field to be a query, where that query is:
Like "*" & [Forms]![Book Return]![Combo20] & "*"

where Combo20 is the combo box with a list of book names, and Book Return is the name of the form.

I don't know how much help this is, but they're a few things to try.
-Mike