sort a subform containing 2 combo boxes

My subform (say MySubform) contains 2 combo boxes which bound by their first
(hidden)column but showing the second column.
Is there a way that I can sort first by Combo1, then by Combo2 whenever the
main form is opened?

I can't do this in the subform's query: it contains only the foreign key
fields to which the combos are bound.

Evi




.

Relevant Pages

  • RE: Combo box storing wrong field
    ... No-When I put in your column widths, I only see the second column in the drop ... "KARL DEWEY" wrote: ... other combo boxes. ... I want it to display the second column ...
    (microsoft.public.access.gettingstarted)
  • Re: How Do I make fields not appear on a form or report
    ... On Apr 18, 11:03 am, John W. Vinson ... the report, not the text. ... field is showing up wrong, and in what way it's wrong. ... change the combo boxes to text fields the "autonumber" appears not the ...
    (microsoft.public.access.forms)
  • Re: Problems setting up datagrid
    ... > from a SQL Stored Procedure in a different order form how SQL returns it, ... but it is showing up last. ... > showing up as simple text boxes, ... > Ron L ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Problems setting up datagrid
    ... > from a SQL Stored Procedure in a different order form how SQL returns it, ... but it is showing up last. ... > showing up as simple text boxes, ... > Ron L ...
    (microsoft.public.dotnet.languages.vb.controls)
  • RE: 2 IDs 1 Name
    ... I'll add to make the size of the second column 0 in the properties of the ... combo box if it is showing and you don't want to see the ID. ... > You would have column 2 as the bound column. ... >> FROM tblMVUP ...
    (microsoft.public.access.queries)