Sort Form by Combo Box Text

  • Thread starter Thread starter David
  • Start date Start date
D

David

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
 
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?
Click to expand...

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]
 
Back
Top