Q
Quin
I would like to add “All†to a combo box to select all records listed in the
drop down box.
I have created a combo box within a form that will select “DayShiftâ€
“SwingShift†or “Grave†employees from a list of employees. The “Row Sourceâ€
type is a value list but I could change that if needed. If I select
“DayShift†“SwingShift†or “Grave†from the combo box, a query returns to
the form only names of employees within that category.
I would also like to have an “All†function that will show the entire list
of employees if it is selected in the combo box.
My query currently uses [forms]![frm_Employees]!Combo10] as the criteria.
I spent several hours today trying to follow instructions from Microsoft
Support at http://support.microsoft.com/kb/210290 That site has some code to
accomplish what I need. Unfortunately after following their directions my
combo box does not include the word “All†or any other options to select. I
believe I am pasting the code correctly into the form and setting the row
source correctly per instructions. I’m not sure if I am following the
instruction for the “Tag†property correctly.
I have also looked at information on using a Union Query Method but I don’t
understand it.
Any suggestions or simplifications on how to accomplish this will be
appreciated.
Quin
drop down box.
I have created a combo box within a form that will select “DayShiftâ€
“SwingShift†or “Grave†employees from a list of employees. The “Row Sourceâ€
type is a value list but I could change that if needed. If I select
“DayShift†“SwingShift†or “Grave†from the combo box, a query returns to
the form only names of employees within that category.
I would also like to have an “All†function that will show the entire list
of employees if it is selected in the combo box.
My query currently uses [forms]![frm_Employees]!Combo10] as the criteria.
I spent several hours today trying to follow instructions from Microsoft
Support at http://support.microsoft.com/kb/210290 That site has some code to
accomplish what I need. Unfortunately after following their directions my
combo box does not include the word “All†or any other options to select. I
believe I am pasting the code correctly into the form and setting the row
source correctly per instructions. I’m not sure if I am following the
instruction for the “Tag†property correctly.
I have also looked at information on using a Union Query Method but I don’t
understand it.
Any suggestions or simplifications on how to accomplish this will be
appreciated.
Quin