Sort Ascending Lookup Wizard

  • Thread starter Thread starter weircolin
  • Start date Start date
W

weircolin

Hi There

I have a table with a field that looks up people's names in another
table, however I can't the records to sort. Is there a way to do
this?

Colin
 
Hi There

I have a table with a field that looks up people's names in another
table, however I can't the records to sort. Is there a way to do
this?

Colin
Click to expand...

I hope you are using a form for data entry, not the table directly.
Entering data directly into a table is a 'NoNo'! And using a LookUp
Field in a table is a double 'NoNo'!!

Do you mean a Combo Box?

Use a form bound to the main table for data entry. Then add a Combo
box to the form. Create a query with all of the fields you need from
the look up table. Sort the query. Then, use the query as the combo
row source instead of the table.
 
I hope you are using a form for data entry, not the table directly.
Entering data directly into a table is a 'NoNo'! And using a LookUp
Field in a table is a double 'NoNo'!!

Do you mean a Combo Box?

Use a form bound to the main table for data entry. Then add a Combo
box to the form. Create a query with all of the fields you need from
the look up table. Sort the query. Then, use the query as the combo
row source instead of the table.
Click to expand...

Hi There

I have been setting it that the user MAY have to enter the data into
the table unless I can get another feature to work. I have had to use
the tables to do te thigns so far rather that quierys to allow the
relationships to work.

Colin
 
Ignore my last post, got what you mean now. Have done this however it
is still not sorting the names.

Thanks

Colin
 
Ignore my last post, got what you mean now. Have done this however it
is still not sorting the names.

Thanks

Colin
Click to expand...

Crystal ball out of order today.
Not able to help ... unless you post the actual combo box row source
SQL.
"Select .... etc ..."
 
Back
Top