Combo Box Values

[lucidity23]

I am not sure if this quation has been answered or not already. When I searched I could not seem to locate an answer.

I have a combo box which is populated by a query. What I need to do is have it so that 2 more options appear at the top of the combo box. The 2 options will not be in alpha order. The query sorts the table data so that the items appear in alpha order.

Is it possible to accomlish this? Let me know. thanks.

http://www.clan-rt.com

- carpe diem -

 

[hammarj]

Instead of using a query to populate the list box, have the rowsource point to a table. This table will be created in a two-step process at form load time or after-update. First add the two top items, then use your original query as an append query to add the remaining elements. You may beed to add a sort order field to the table. A liitle kludgy, but it will work.