Re: sort a subform containing 2 combo boxes

Tech-Archive recommends: Fix windows errors by optimizing your registry



On Sun, 23 Nov 2008 17:29:58 -0000, "Evi"
<evwool@xxxxxxxxxxxxxxxxxxxxx> wrote:

But you can change that query to include the Column1 values. That's
indeed somewhat unusual, but seems to me appropriate in your case.

-Tom.
Microsoft Access MVP


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

  • Aggregate string concatenation efficiency problem
    ... retreiving the data for the results listview from the query through ... More than one Consultant can be listed on a Sale, ... (a string concatenation aggregate function, for instance), and I could ... Customers.FullName AS Column1, Sales.SaleDate AS Column2, ...
    (comp.databases.ms-access)
  • Re: ComboBox to update TextBoxes on Form
    ... Me.Query1.Requery really is meaningless. ... Column1 = State ... Query1 is linked to a Table with some data on the 50 states. ... "when I run the query"? ...
    (microsoft.public.access.formscoding)
  • Re: SQL bug?
    ... The problem was due to parallelism. ... Modifying the query to not use ... > The problem occurs when the optimizer uses the Column1 index. ... >>create table tbl ...
    (microsoft.public.sqlserver.programming)
  • Re: Grouping Problem????
    ... If anyone else has a more elegant solution I would be very grateful to see ... In your first query, get the Max of your column1, GroupBy ... I want to extract from this a refined query showing the line for each ...
    (microsoft.public.access.queries)
  • Re: Non-updateable query issue
    ... Microsoft Access MVP ... When putting together that query, ... "Duane Hookom" wrote: ... Say Fred deletes record 79 from Table1, ...
    (microsoft.public.access.queries)