G
Guest
I have a form that has a combo box based on a query of a couple tables. When
you select a field from the drop down list the form shows all the data for
that field. That part is working fine.
One of the fields in that query is either the word "Fall" or "Spring".
I've added another combo box to the form that is a value list that I have
seeded with the words "Fall" and "Spring".
What I want to happen is for the use to first select a season (fall or
spring) and then go to the MoveTo combo box which, when clicked, would only
show those records where the season field is the same as what was chosen in
the value list.
It works the first time, but if I then change from say, fall to spring, in
the value list, the choices in the moveto combo box still show the "old"
season.
Essentially I want to refine the search criteria on a combo box on the fly.
I haven't been able to figure out where to put the requery, or if that is
even what I need to do.
Thanks in advance.
Jerry
you select a field from the drop down list the form shows all the data for
that field. That part is working fine.
One of the fields in that query is either the word "Fall" or "Spring".
I've added another combo box to the form that is a value list that I have
seeded with the words "Fall" and "Spring".
What I want to happen is for the use to first select a season (fall or
spring) and then go to the MoveTo combo box which, when clicked, would only
show those records where the season field is the same as what was chosen in
the value list.
It works the first time, but if I then change from say, fall to spring, in
the value list, the choices in the moveto combo box still show the "old"
season.
Essentially I want to refine the search criteria on a combo box on the fly.
I haven't been able to figure out where to put the requery, or if that is
even what I need to do.
Thanks in advance.
Jerry