Prev: Want Users Cursor To Always Go To Beginning Of Field
Next: Accdr
From: MichelleM via AccessMonster.com on 29 Jan 2010 15:54
I have several forms set up that use a combo box to choose a leader. When
the report runs from the form, it brings back the data for just that leader's
team. Is there a way to have an "ALL" option so that all teams appear?

Thanks!

--
Message posted via http://www.accessmonster.com

From: Douglas J. Steele on 29 Jan 2010 17:43
See http://www.mvps.org/access/forms/frm0043.htm at "The Access Web" for how
to add an entry for "All" to a combo box.

Change the criteria of your query from

WHERE MyField = Forms!MyForm!MyComboBox

to

WHERE MyField = Forms!MyForm!MyComboBox
OR Forms!MyForm!MyComboBox = "All"

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"MichelleM via AccessMonster.com" <u44423(a)uwe> wrote in message
news:a2d9f6185912c(a)uwe...
>I have several forms set up that use a combo box to choose a leader. When
> the report runs from the form, it brings back the data for just that
> leader's
> team. Is there a way to have an "ALL" option so that all teams appear?
>
> Thanks!
>
> --
> Message posted via http://www.accessmonster.com
>


 | 
Pages: 1
Prev: Want Users Cursor To Always Go To Beginning Of Field
Next: Accdr