Filter form records with a combo box

[Exmark1]

I have a relational Database in Access 2007 for Lawn Service customers , and on my main form called customer information which is a single form, I want to have a combo box with Active, Inactive , and All to be able to select and I could alternate between each group.
In the forms control source select query I have a field called Status where every customer is either active or inactive. Currently to see my inactive customers I have to open another form call Inactive customers with Record source Inactive customer query, and I thought it would be neat to be able to toggle from active to inactive or All customers on the same form .



I am new to Access so if anyone has a solution to how to do this I would appreciate the help

[rpeare]

If you want to search for the status you have to provide an UNBOUND combo or text box that lists the status, then when the value is changed (either ON CHANGE or ON EXIT property of the unbound combo) you would requery your form.

[Exmark1]

I do have a unbound combo box that displays the Active and Inactive status from a cross tab query when I select the drop down, and I have in the Change property of the combo box me.requery that does not work to requery the form and display inactive customers. the form displays active customers when opened anyway.

[rpeare]

the query driving the form must have a criteria in the 'status' field of [forms]![formname]![statusfield] or requerying will have no visible effect.

[Exmark1]

I am lost on this one what would the criteria reference. the combo box is in the form header of my ' Customer Information Form' is named Status. Which is populated with Active and Inactive choices by a crosstab query . This form data is from "active customer query" which has the Status Field. [Forms]![Customer Information]![Status]
Confused help!

[June7]

Form has RecordSource, data controls (textbox, combobox, etc) have ControlSource. Is the CROSSTAB a RecordSource or ControlSource?

A CROSSTAB query is seldom practical for form RecordSource as data cannot be edited. CROSSTAB query requires parameter definition for filtering, review http://allenbrowne.com/ser-67.html#Param

Since there is no value "All" in the data, selecting that from combobox will not filter records - no records match that criteria. Review http://www.allenbrowne.com/ser-62.html