Combobox filter

[jown]

I`m using access 2010 version, i have one table(Customer) which has one-to-many relationship to the table(Order), so the Order table contains many records from one single record in Customer. How to create a combobox that filter and show how many orders the Customer has.
Example:



Table(Customer)
Line 1 - Crystal

Table(Order)
Line 1 - Water
Line 2 - Cookies
Line 3 - Pens

[June7]

You want an unbound combobox to use as criteria for filtering records?

Do you have a form/subform arrangement for the Customer and Order records?

Could build a report to output this data.

[jown]

Hey June7,

Thanks for your response and for your hint,

I`ve created main form based on Customer and the Order is in tabcontrol(dragging the fields which are relevant in tabcontrol). So I want my unbound combobox to show a list of orders from client, it will show in client 1 how many orders....When i click in one item of the list the information will appear in tabcontrol.
In this case how to proceed?

[June7]

You have the Order table bound to a subform sitting on main form bound to Customer? Review: http://office.microsoft.com/en-us/ac...010098674.aspx With this arrangement there is no need for a combobox to show customer orders.

Alternative is a single form bound to Order table and just a combobox to select customer.

[jown]

June7,

In my case, the tab control display shows only relevant fields and it is more easier to get what the client ordered. So That's why i've create my form this way, however i've built the form like the way you said and it's not bad but it is not efficient for me. Thanks for all your time and help. I 'll figure out another way to work with combobox and reports.