J
josh
Hi,
I'm sure this has been answered a billion times already, so sorry if
this is a repeat...
I found a few ways to filter a listbox based on a selection in a
combobox. Here is one solution:
http://www.mvps.org/access/forms/frm0028.htm
My question is a bit different:
I also want to have the first value available in the combobox be
something like "(All)" which will basically remove the filter that
limits what is selected in the listbox.
Q1: How do you add a value to the combo (like "All") if it's
recordsource is a query?
Q2: Should I hook up the AfterUpdate event of the combo to execute the
filtering as suggested in the mvps article mentioned above?
Background for Q3: This is a bit off course, but here it goes: What I
am building is form that will allow a user to select email addresses
(filtered by department) and add them to some sort of list (not sure
how the list will be implemented yet). These email addresses will be
used for an automated email notification when certain events occur.
I'm trying to architect a solution for holding these addresses. One
option is a normalized structure but that seems over-built. Another
option is to store the selected addresses in a memo field, but that
seems nasty.
Q3: Anyone have a better idea of how to accomplish the task at hand?
Thanks for your time,
Josh Blair
Evergreen, CO
I'm sure this has been answered a billion times already, so sorry if
this is a repeat...
I found a few ways to filter a listbox based on a selection in a
combobox. Here is one solution:
http://www.mvps.org/access/forms/frm0028.htm
My question is a bit different:
I also want to have the first value available in the combobox be
something like "(All)" which will basically remove the filter that
limits what is selected in the listbox.
Q1: How do you add a value to the combo (like "All") if it's
recordsource is a query?
Q2: Should I hook up the AfterUpdate event of the combo to execute the
filtering as suggested in the mvps article mentioned above?
Background for Q3: This is a bit off course, but here it goes: What I
am building is form that will allow a user to select email addresses
(filtered by department) and add them to some sort of list (not sure
how the list will be implemented yet). These email addresses will be
used for an automated email notification when certain events occur.
I'm trying to architect a solution for holding these addresses. One
option is a normalized structure but that seems over-built. Another
option is to store the selected addresses in a memo field, but that
seems nasty.
Q3: Anyone have a better idea of how to accomplish the task at hand?
Thanks for your time,
Josh Blair
Evergreen, CO