combobox question

[billcar2006]

Does anyone know how I can get a combo box to show only the last id in its list when the form loads.

[NTC]

one has to define 'last' in database terms. a combobox is a record set and that record set can be a query. so perhaps that means using 'Max' style aggregate query....one can't say. In general a combobox is to show multiple items and therefore to want it to show just 'last' then it is only showing a single item which is a little odd.