Creating Combo Box from a Table with Custom 1st Item

[itchibahn]

I'm trying to create a combo box that lists all the names from a table, but I want the first item to be "Add New". I think I can do it by:


1. loading all the names from the table into an array starting at array[1]
2. insert "Add New" to array[0]
3. use array to build combo box

Is there any simpler way than this? If the table contains huge number of records, it could e a memory hog...

Thanks.

[pbaldy]

I'd just use a union query

http://access.mvps.org/access/forms/frm0043.htm

[itchibahn]

Exactly what I was looking for!
Thanks..

[pbaldy]

Happy to help!