Lookup Wizard indexing

  • Thread starter Thread starter Ann Shaw
  • Start date Start date
A

Ann Shaw

Hi I have a table (just one little table) with one of the
fields as department. This dropdown has for example 12
departments type in in no particular order.

I was wondering if it is possible to sort this in the list
after typing them into the Lookup Wizard - I tried going
to the lookup tab in table properties and clicking on ...
but I am getting a message to say that the table is opened
exclusively ?? this brings me into a query (sql??) and I
am trying to sort there but Access won;t let me - is there
a way to do this easily???

Many thanks
 
is there
a way to do this easily???
Click to expand...

Yes.

Don't use the Lookup wizard AT ALL. It's not necessary, it's
inefficient, and it conceals the actual contents of your table.

Instead, create a Form; you can put a combo box on the Form, based on
a sorted query of the departments. Table datasheets are of *very*
limited utility and should only be used for debugging, and you don't
need a lookup field in order to use a Lookup (a combo box) on a Form.
 
Back
Top