Historical Data & re-sorting new data

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?
--
Lady Chalkley

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

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


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?

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.

"Lady Chalkley" wrote:

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?
--
Lady Chalkley