List Box Query - Forms

[b_a_redman]

Hey,

I have a form with two combo boxes, Combo0 and Combo2, i have based these
combo boxes on two columns within my table, Tasks. What im trying to do is,
once the user has selected a value from either combo box, all the records
with that value selected are displayed in a list box. If both combo boxes
have values selected the amount displayed in the list box is shorter because
the query is shorter. I have no idea where to start on this.

This is all to do with tasks within a company. One user can conduct many
tasks in a variety of departments, so when i select the user and the
department, it will display all the task that are stored in the database,
onto the list box.

Combo0 based on column name Department
Combo2 based on column name User

search is the form name
Tasks is the table name

 

[Arvin Meyer [MVP]]

Have a look at the sample at:

http://www.accessmvp.com/Arvin/Combo.zip

for some ideas.

 

[b_a_redman]

Thats useful thankyou, but how do i get everything displayed in a list box
rather then several fields. So i select somefing from Combo1 and Combo2 and
all the results are displayed in the list box

Thanks
B

 

[Arvin Meyer [MVP]]

It drills down. The first selection limits the second. The second selection
filters what's returned on the form.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com