combo box acts as a filter

[access my brain]

I'm using access for the first time. I have a combo box on a form, I'd like users to select an item from the combo box and that will return all form records containing that item. The same as applying a form filter but easier for the user

Is there a simple way to do this without VB script!?!

Any help much appreciated

 

[jeremie_ingram]

Try adding a new combo box to the form. Whe you do you should be prompted with three options. Choose the third option "Find a record on my form based on the value I selected in my combo box", to get the results you want. If you already have the data source set properly (data shows up in Form view) then a combo box can do this for you. Be sure you are adding a NEW combo box to the form and these options will be presented to you.

 

[access my brain]

many thanks all sorted