C
Chip
Howdy!
I am relatively new to ACCESS and i am using ACCESS XP to build me a
database for my Company's Customers. I have built a form that shows all of
my customers in Datasheet view but i would like to have combo box that i can
select the type of customer (like Service providers, material providers, or
both) and it only show those type of customers. (the customer type is a
field of the form that i am trying to filter.) Currently I have built a
form that has a single combo box and then i placed a "open form" button that
then opens the form filtered by the combo box and it works fine but if i
want to filter by another customer type i then have to go back to the first
form that has the combo box and reselect the new customer type and hit the
"Open Form" button again. I tried a subform but could not get it to work
correctly if i wanted to change the customer type of a customer that was
filtered by another customer type it seemed to change what i wanted it to
and also the first record of the filtered set. So i am lost at this
point....
I know this should be easy so i am a little embarrased about asking about
this but i have spent 6 hours trying to make this work and just cannot seem
to get it. If anyone can offer some assistance on how i should do this
please let me know!!!
And as always, THANKS IN ADVANCE!!!
I am relatively new to ACCESS and i am using ACCESS XP to build me a
database for my Company's Customers. I have built a form that shows all of
my customers in Datasheet view but i would like to have combo box that i can
select the type of customer (like Service providers, material providers, or
both) and it only show those type of customers. (the customer type is a
field of the form that i am trying to filter.) Currently I have built a
form that has a single combo box and then i placed a "open form" button that
then opens the form filtered by the combo box and it works fine but if i
want to filter by another customer type i then have to go back to the first
form that has the combo box and reselect the new customer type and hit the
"Open Form" button again. I tried a subform but could not get it to work
correctly if i wanted to change the customer type of a customer that was
filtered by another customer type it seemed to change what i wanted it to
and also the first record of the filtered set. So i am lost at this
point....
I know this should be easy so i am a little embarrased about asking about
this but i have spent 6 hours trying to make this work and just cannot seem
to get it. If anyone can offer some assistance on how i should do this
please let me know!!!
And as always, THANKS IN ADVANCE!!!