Historical Data & re-sorting new data

[Lady Chalkley]

Hi,

How do I add new drop down box options, re-sort so that it appears at the
top of the drop down selection. Will this affect the historical data?

 

[Tom van Stiphout]

On Tue, 16 Jun 2009 19:58:01 -0700, Lady Chalkley

You're really not providing enough information. Is this a dropdown
bound to a query? Have you considered using the NotInList event (see
help file) to add new items?
Data is sorted using an ORDER BY clause in the underlying query.
No, existing data is not affected.

-Tom.
Microsoft Access MVP

 

[KARL DEWEY]

I think I follow - personnel have departed so they should not be chosen but
still exist so as to display.
I add a field, something like Departed (Yes/No) and then use a sort in the
select statement like this --
SELECT EmpID, Name, Departed FROM MyTable ORDER BY Departed, Name;
This sort the non-Departed first and then by name. I displays the employee
status while making selection.