Re: adding the word "All" to a combo/list box

"bobh" <vulcaned@xxxxxxxxx> schreef in bericht
news:f888589a-d9cc-45e3-871b-0d055a33d737@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

I want to add the word "all" to the top of a combobox or a listbox? I
remember sometime way back I did it in one of my apps but I can't find
it anywhere and I don't remember how it was done but I got it from
here. I also tried doing a serch here but could not find anything that
helped.
thanks
bobh.

If the combo's record source is a query you could replace that by a union
query which consists of the original query and a query that adds "All".
Lars


.

Relevant Pages

  • Re: Query Combobox Problems
    ... also I can't seem to get the listbox to run the query ... again if I update the combobox. ... havn' found one yet using this method to populate a listbox) ...
    (microsoft.public.access.queries)
  • Re: Sorting listbox contents
    ... Sort list box by column when column is right-clicked ... 'Install call to this code in the Mouse Down event of a listbox. ... Dim iLoop As Integer ... MsgBox "List box must use a query as it's row source" ...
    (microsoft.public.access.modulesdaovba)
  • RE: Help - Updating table entries selected in Listbox
    ... update query to that file....once this trial works correctly then in design ... a multi-select listbox called listboxFileList ... The combobox is populated from ...
    (microsoft.public.access.forms)
  • Re: REPOST: Problem With Listbox Selected Property
    ... The queries are shown below. ... the first query is very simple and the second query is a ... year has not been selected in the lstFY listbox. ... >>> sub procedure. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Help - Cant understand Code
    ... Listbox with MultiSelection used in Query ... I have the sample database in its orignial form. ... The subform doesn't have a SELECT statement however the query it is bound ...
    (microsoft.public.access.forms)