combo with 2 column

[ebiscaro]

I have this combo box which has two colum: tool and tool size.
This combo controls a subform linked to "tool". I was wandering can I sort the data in my subform using both the column in the combo box?
Thank you

 

[WayneRyan]

ebiscaro,

The subform has an order by property, but what is the current
ordering? By Tool? By Tool size? Is the subform based on a query?

How would you like to change it?

Wayne

 

[ebiscaro]

Thank you

Yes the subform is based on a query. At the moment I have two combo boxes. With one you choose the "tool" with the other the "tool size". Once trhe two selections are made the subform shows the data filtered by "tool" and "tool size".

I whish, if possible to have only one combo with two column Column 1 "tool" Column 2 "tool size".

toolA size1
toolA size 2
toolB size 1
toolB size2

When you choose one the subform should appear with data filetered by tool and size, without going through two choices.

About the ordering I am not sure, data are ordered by tool and tool size I guess

I hope this is clear
Thank you again

 

[WayneRyan]

ebiscaro,

Keep your query for the subform. In the criteria section under
Tool and ToolSize, put

=Forms![YourForm]![YourCombo].[Column(0)]
=Forms![YourForm]![YourCombo].[Column(1)]

I think that is the syntax. The column counters start at 0.

Wayne

 

[ebiscaro]

The query works just fine now, and the subform too. The problem is that when I open the main form where the combo with two column and the subform are. Instead of opening the form and showing me an empty subform, Access asks me to fill in the value. Once I fill them in it works fine. It does not work at all when I pick the value form the combo.


The subform is linked like that to the combo
Link Child Field: ToolName
Link Master Field: Tool size

I guess that because there are two colums it canno find the ToolName anymore so it won't open.
thank you

 

[WayneRyan]

ebiscaro,

By asking you for the values that means that Access either; does not
know the names used in the criteria in the query, or they have no
default value.

Wayne