add values to limit to list

[salmonella]

I have a combo box that is using a query to a table to populate the choices
displayed in the box. The combo box is set to limit to list. Is there a way
to modify the query (or somehting) so that it will return the values from
the query and a few others that I want to add?

thanks

 

[Dorian]

You need to add those values to the table the query is reading.
The source for a combo box can be a table/query or a value list but not a
combination of the two.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "NotInList.mdb" which illustrates a number of different ways
to do this. You can find it here:
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=311

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L