|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 29th, 2010, 08:54 PM
posted to microsoft.public.access.forms
|
|||
|
|||
Combo Box - Can I choose more than one?
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 
|
|
#2
January 29th, 2010, 10:43 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Combo Box - Can I choose more than one?
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@uwe wrote in message news:a2d9f6185912c@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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
