Drop Down Menu Parameters

[spoonman]

Some what new to Access. I have a project im working on and need a little help and direction of how to accomplish this task.



What im trying to do is i want to drop down menu only select curtain query's when other field match up.

Diagram:

Column 1
Female
Male

Column 2
Item1
Item2
Item3
Item4
Item5
Item6

Column3
Item1 Male
Item2 Male
Item1 Male
Item4 Female
Item5 Female
Item6 Female
Item7 Junior
Item8 JuniorS

so to help you better follow me i added a fake diagram but simuilar to what i want to do.

so if i select male in column one and also select item 2 in column two i only want item 3 in column 3 to show up in the drop down list.

anyideas?

i thought i iff statement or choose statement would work but havent figured them out.

[June7]

You are trying to do this in a table. Not possible. This must be done on a form as it requires code.

Build a form to interface with table using dependent (cascading) combo and list boxes. Check this tutorial http://www.datapigtechnologies.com/f...combobox2.html

However, even this will not work well if the form is displaying in Datasheet or Continuous View.

[spoonman]

Thanks for your help that video helps; but its asking me each time for a Parameter Value. i dont want a Parameter Value how do i just have sort through the list of values.

[June7]

If you are getting a prompt then setup is not correct. The input should be from the form.

I don't really understand what you want to show in the third combobox. Your diagram did not attach to post.

[spoonman]

ive change it two combo boxes.

Column1
m-Demo
w-demo
m-performance
w-performance
junior
m-snowboard
w-snowboard
j-snowboard

column2
is a product list

the query im using for column 2 has the following information inside
Equipment id
equipment type
package type
make model size (of Product)

Combo box one
is my own list i type in (listed above in the column one)

Combo box two
is the list pulling from my query discribe from above.
im only pulling the information from make model size and i included equipment id .

i only want column2 to bring up m-demo ski's products if its selected in column 1. and the same for all the others. watching his video was great, but i think i might be missing a setup on setting up a tree list or tree view im not to sure.

i hope this helps out a little more.

[June7]

Can't advise with knowing specifics of your data structure. You have a table that relates products with the categories of combo 1?

Show combo 2 RowSource SQL statement.

Post project for analysis.