Combo Box Management

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I may be trying to do somthing that can't be done, but here's the scenario:

I have a combo box (or a drop down box).
It displays records (rows) from a table’s description field.
It’s row/source type is a table query.
The combo box displays the rows in the order they were entered into the
table.

Question:

Is there a way or a utility I can use to let my clients re-arrange the
descriptions within the combo box? I would want this to result in
rearranging the actual row (record number) and placement of the record within
the table.
 
DanBair said:
I may be trying to do somthing that can't be done, but here's the scenario:

I have a combo box (or a drop down box).
It displays records (rows) from a table’s description field.
It’s row/source type is a table query.
The combo box displays the rows in the order they were entered into the
table.

Question:

Is there a way or a utility I can use to let my clients re-arrange the
descriptions within the combo box? I would want this to result in
rearranging the actual row (record number) and placement of the record within
the table.
Click to expand...


Actually, the records are display in an arbitrary order.
They may or may not be displayed in the order of their
primary key, not necessarily the order they were entered.
Their placement in a table's sheet view is also not
predetermined, even if it is uaually sorted by the primary
key value.

To display the records in a specified order, you must use a
query as the combo box's Row Source. This way, you can
specify how you want the records to be sorted.

To accomplish that, you need to have a field in the table
that contains a value that can be sorted. This means you
need to add a column (name it something like SortingField)
and enter a number into each record to place it in the
desired position in a query sorted by that field.
 
Is there a way or a utility I can use to let my clients re-arrange the
descriptions within the combo box?
Click to expand...

Not within the combo box itself, no.

You could open a popup continuous Form to allow the users to edit the
table of course. Requery the combo in the form's close event to
reflect the changes.


John W. Vinson[MVP]
 
Back
Top