Adding items to combo boxs

[John Martens]

Is there a way to add an additional item to a combo box? I
have several comboboxs that are based on queries and are
used for various purposes on my form. For example if I
select an item from one of the combobox I do a requery of
the form that is specific to that value. The problem I
have is that I can not get back to show all the values.
What I was trying to do to accomplish this was use the
additem, that I am used to in VB, to the combo box and add
an * which would be used in the criteria of the combo box.
But that does not seem to work.

Any help would be appreciated. I have been reveiving great
replies to my earlier posts, and hope I can be of help to
some of you in the future!

Thanks again!
John M.

[Brendan Reynolds (MVP)]

Access 2002 and later have an AddItem method, but to use that the row source
of the combo box has to be a value list, not a table or query. There's an
example of how to add a new item to a combo box based on a table or query at
the following URL:

http://www.mvps.org/access/forms/frm0015.htm

--
Brendan Reynolds (Access MVP)
bren...@indigo.ie

"John Martens" <jmar...@docmar10s.com> wrote in message
news:055001c316b1$95c209d0$a101...@phx.gbl...