order by

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.

BruceM wrote:

If you base a form on a query rather than directly on the table you
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?
" wrote:


I have a subform with three fields on it. The subform is based on a
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.

Dale Brown

A query is updatable (within a few understandable restrictions)

wrote in message
...
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.

BruceM wrote:

If you base a form on a query rather than directly on the table you
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?
" wrote:


I have a subform with three fields on it. The subform is based on a
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.

Dale Brown

It depends on how you identify the query. The query must also be based on
one table.

"JohnFol" wrote:

A query is updatable (within a few understandable restrictions)

wrote in message
...
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.

BruceM wrote:

If you base a form on a query rather than directly on the table you
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?
" wrote:


I have a subform with three fields on it. The subform is based on a
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.

Dale Brown

"Klatuu" wrote in message

It depends on how you identify the query. The query must also be
based on one table.

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)

I stand corrected

"Dirk Goldgar" wrote:

"Klatuu" wrote in message

It depends on how you identify the query. The query must also be
based on one table.

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)