Multiple Combo Boxes to filter a query

[Matt Scheetz]

I've got a main form with three combo boxes (City, State,
& Name) With these I have a subform to display the data
based on the selected criteria, along with other data
associated with each customer. I cannot get the data to
display using more than one combo box.

Any adivce?

 

[Jeff Boyce]

Matt

What is the record source for your subform? I.e., how does it know to use
the three combo boxes?

Do you "refresh" the display after making a choice in each/every combo box?

 

[Carla Thistle]

Hello Mat,

I am having the same problem, only I didn't use a subform. I just created
the main form using a query of the table. I then have added unbounded combo
boxes to the form as search criteria. I've tried macros and what if
statements in the query itself, but still can only get results for one combo
at a time. I am finding help though. If you look for my name, you will find
information there that will help. Look for Carla Thistle dated Jan 19, 2004.

If you recieve a solution before I do, please let me know.

Thanks,
Carla

 

[Guest]

When I want to do something like this...
I set up 3 text boxes to accept the results of the CHANGE
event on the combo boxes. I then reference these TEXT
boxes in the query and all works fine.

Many people have difficulties passing the contents of the
combo box DIRECTLY into a query...so the intermediate step
to a TEXT box always solves the problem.

Try it.
For example, this is how the TEXT box value is set from a
combo box with the 4th column being the value I want to
capture.
=[Forms]![frmCostElementBucketingCOMP36BucketsAfeDimsSap]!
[cboSelectAWell].Column(3)

Good luck.
Robert W.

 

[Jeff Boyce]

Robert

Certainly workable, but I haven't run into a situation in which I needed to
use this additional layer of controls. Perhaps the value being filtered on
is not the primary key?

Thanks!

Jeff Boyce
<Access MVP>