order by

  • Thread starter Thread starter dale
  • Start date Start date
D

dale

What I am trying to do is update a table in the subform. The data being
display is horse number and name, rider name, and order number. The
combo box for horse number and name is based on a horse id field in the
table. The rider name is based on a rider id in the table. I want the
subform to be ordered by the horse number. From what I understand if I
use a query to get the data I want I will not be able to update the
table directly like I can when using the table itself as the
recordsource. Let me know what you think.
If you base a form on a query rather than directly on the table you
Click to expand...
can order by a field. I'm not sure what you mean by ordering the
subform data based on the value returned in the combo box. Do you want
the order to change based on the combo box selection?
:
Click to expand...
table. One of the fields is setup as a combo box and I have a query that
I use to populate the combo box. The query returns data based on the id
of the field in the table. I would like to have the subform ordered by
the value returned in the first fields combo box. How can this be
accomplished.
 
Klatuu said:
It depends on how you identify the query. The query must also be
based on one table.
Click to expand...

Just a note: it is not necessarily the case that a query based on more
than one table is not updatable. Queries based on two tables in a
many-to-one relationship are generally updatable, provided that certain
conditions are met.
 
I stand corrected

Dirk Goldgar said:
Just a note: it is not necessarily the case that a query based on more
than one table is not updatable. Queries based on two tables in a
many-to-one relationship are generally updatable, provided that certain
conditions are met.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Click to expand...
 
Back
Top