|
| 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
April 5th, 2007, 03:31 PM
posted to microsoft.public.access.forms
|
|||
|
|||
Filter by Combobox, add ALL selection?
How can I add an ALL option to a combobox I'm using to filter a subform? The
combobox is based on a SELECT DISTINCT query, and I don't want to add an ALL record to the table... this is probably incredibly simple, but I simply can't get it! =/ TIA, Susan 
|
|
#2
April 5th, 2007, 04:02 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Filter by Combobox, add ALL selection?
Check this link on "Adding "All" to a listbox or combobox"
http://www.mvps.org/access/forms/frm0043.htm -- Good Luck BS"D "SusanV" wrote: How can I add an ALL option to a combobox I'm using to filter a subform? The combobox is based on a SELECT DISTINCT query, and I don't want to add an ALL record to the table... this is probably incredibly simple, but I simply can't get it! =/ TIA, Susan
|
|
#3
April 5th, 2007, 04:49 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Filter by Combobox, add ALL selection?
Thanks Ofer,
This is working perfectly now! Major brainfart, didn't even think of using a UNION query, doh! Thanks tons, SusanV "Ofer Cohen" wrote in message ... Check this link on "Adding "All" to a listbox or combobox" http://www.mvps.org/access/forms/frm0043.htm -- Good Luck BS"D "SusanV" wrote: How can I add an ALL option to a combobox I'm using to filter a subform? The combobox is based on a SELECT DISTINCT query, and I don't want to add an ALL record to the table... this is probably incredibly simple, but I simply can't get it! =/ TIA, Susan
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
