Sub Form & Combo Box

[leighms]

HI
I have a table that lists customers, their branch and how long since they transacted with us. What I want to do on a form is have a combo box that lists the branches and once you select the branch it gives you a list of customers that have been inactive for a certain time period.
I have set up a query that will give me a list of customers that have been inactive for certain period, I just cant get the combo box and sub form to link????

 

[Ranman256]

you could make a table, tQrys, to fill the combo.
In it is
[Caption], [Qry]
Customers Inactive , qsCustInactive
Customers Active, qsCustActive
Customers All, qsCustAll

user selects the item in the combo, they see 'customers Inactive'
but the combo is bound to col 2, the comb is now = qsCustInactive
click the open button to open the query
docmd.openquery cboBox