Shoutbox

can anyone tell me how you make a drop down box (using look up wizard) that when u select a certain one gives u certain fings to choose from in a diferent field ....a bit like a tree diagramm


nokia - model1
            model 2
Panasonic -
                    model XV
                    model XC


(nokia and panasinoic being the choices in the first drop down box) and (model ** being the answers for selecting nokia or panasonic)


sorry if this is confusing

Google Search: http://www.google.ca/search?hl=en&ie=UTF-8&q=Java...down+menus&spell=1

Site From Google Search: http://www.searchbliss.com/webmaster_tools/javamenu.htm   

thanks but dont seem to help.....is there like a button or a wizard in ms access where u can do this?

You could try using VBA.
When you change the selection in the first, it fires an event. In this event, repopulate the second listbox with the relevant items.

quote:

---

Originally posted by DJeX
Google Search: ......
Site From Google Search: ......

---

Javascript hasn't got anything to do with this...

quote:

---

Originally posted by raceprouk
You could try using VBA.

---

You even don't need VBA to do this

----

hint: All you need to do is creating the dropdown menu and let it depend on a query which takes its input from the first dropdownbox. Nothing needs to be programmed as this is a basic Access database thingie; this can easly be done by Access itself and some wizard (lookup wizard or whatever, it has been a while since I worked in access and I don't know all the menu's, etc from the top of my head and I haven't got it installed atm to show you)...

i NEED this in ms access, do u no the name of this function? thanks cookierevised.....

erm, it isn't a single function... it is just basicly how access works....
When you add a dropdown on a form (and you have the wizard thingie on) it will ask you from where you want to get the input:
1) use a table/query/whatever (<= what you need to select)
2) type the input yourself (as in make your list right now)

As I said, it is a bit complicated to explain in words. Maybe you should try and find a tutorial of Access on the web. Or a book in the library. Because working with queries, rerouting the output, using tables, etc.. that's all basic Access stuff...

I'm sorry I can't help you more...

i fink i get it...kinda, thanks a lot...its cleared a lot of crap up

make a new form in design view.
select combo box.
draw in the box where you want it
the wizard will come up and ask if u want to look up the values from a table.
slect yes and then tell it which table to look up.


then to make your second drop down box, u will need to create a relationship between the two table, so that it knows which values to look up.

how this helps !!!! if it doesn't then i will try explain it better later. busy atm and don't have access to access.

THANKS LOADS toddy....im reli new to this and need it for coursework.....so nefing ne1 knows is helpful!