combo box question

[billcar2006]

Is there a way to get a combo box to only show the last id no in its list.

[John_G]

You would have to modify the row source for the combo box to a) reverse the sort order and b) select only one record, for example:

Select top 1 fieldlist from Tablename order by sortfield desc

Replace fieldlist, tablename and sortfield with the actual names you use in the combo box.

[billcar2006]

Thanks for your answer. All I wanted was an easy way to select the last id. I had the list ordered ascending. I never thought of changing it to defending.sometimes you miss the easy sort when you get an idea stuck in your head.