apply filter so that drop down includes only results of filter

  • Thread starter make a VBA to export pivot chart to word
  • Start date
M

make a VBA to export pivot chart to word

after i have applied a filter in datasheet view why is it that the drop down
includes values that do not relate to the selection made by the filter what
can i do to restrict the drop down values to only the filter selection
 
K

Klatuu

What the combo shows has no relation to what is in the table. If this were
true, you would never be able to use a combo to select a value for a new
record. You will have to do something in the combo that will match the
filtering for the record source for your form.
 
M

make a VBA to export pivot chart to word

sorry i must have worded this wrong it is not a combo box. when i used the
filter by form button, each field has a little drop down button by the side.
So say i filter based on state and i get down to california why is it that in
my contact field i will have people who are not in california showing in the
contact drop down.

Secondly, how could i choose multiple records at once. Again using this
above example say i have jon, jane and july in california however i want just
jon and jane, and i also want to chose jason from colorado and i want all
three selections on one page how do i do that. I spent a lot of time playing
around with the filter by form and filter by selection button to no avail.
Any help will be more than welcome
 
K

Klatuu

I suggest you change your form and use a list box. It will allow mulitple
selections, and after each selection, you can requery the row source to do
what you want.
 
Top