Combo list order

[Parker]

I have a constantly expanding list looked up by a combo box.


Is there anyway of getting the combo box to display the last item added to the list by default?

Tried searching for this all day but can't find answer.

Thanks

 

[dcx693]

What is the rowsource for your combo box?

 

[Parker]

A paramiter query that concaternates 2 columns and the result from a Max query that is formated to allow leading zero's

PARAMETERS AccountType Text ( 255 ); SELECT ClientAccount!AccountType & ACExp!AccountNoExp & ClientAccount!BookingCode AS Expr1 FROM ClientAccount;

Thanks

Pete

 

[WayneRyan]

Parker,

If you sort them by date entered DESC (assuming that you
added a field for that) then, I'm quite sure that whoever uses
it will ask you if there is any way to show them alphabetically.

An option might be to put a command button. Its caption
toggles between "Sort by date" and "Sort Alphabetically".

When pressed, it can:

Me.YourCombo.RowSource = "Select ..."
Me.YourCombo.Requery

Wayne

 

[Parker]

Thanks for your reply Wayne.

If you sort them by date entered DESC

In this instance I don't see how that would work. This routine will develope a group of 8 each time it runs. So we would have 8 all generated within milliseconds of each other.

whoever uses it will ask you if there is any way to show them alphabetically.

Again, while point taken, not really relevant and I cant see anything logical to sort on add to that if I try and add anything else to the query it blows up.

 

[WayneRyan]

Well Parker,

Just sort the list on Date DESC and let the chips fall where
they may:

Me.Combo.Requery

Wayne