Sort Form by Combo Box Text

Is there a way to sort a form on a non-bound column of a combo box? For
example, in a form with a record source set to a table of books, the
"Category" combo box has its bound column set to the category ID column and
displays the category text, but the category text isn't in the recordset of
the form. Is there a way to sort the form on "Category" without changing the
record source of the form?
Thanks in advance!
David

On Fri, 06 May 2005 16:54:57 GMT, "David"
wrote:

Is there a way to sort a form on a non-bound column of a combo box? For
example, in a form with a record source set to a table of books, the
"Category" combo box has its bound column set to the category ID column and
displays the category text, but the category text isn't in the recordset of
the form. Is there a way to sort the form on "Category" without changing the
record source of the form?

Not efficiently.

Why not base the Form on a query joining the books table to the
Category table, and sorting by category? With a single, simple join
like this you won't be hurting the updatability of the form.

John W. Vinson[MVP]