Value in Textbox 2 depends on Value on Textbox1

[dizy8]

Hi all,
I have textbox1 that has a drop down selection of (Station, Tunnel, MEP). Now, I want that when I select “Station”, my textbox2 will have a dropdown select of (Mary, John, Peter) and when I select “Tunnel”, ill have a dropdown select of names (Nina, Ana, Gin) and if I select “MEP” Ill have a drop down selection of names (Apple, love, Faith) only.

Anyone can help me of the codes please. Do I have to make a table of each set of names?

[Welshgasman]

They will be combos, not textboxes, if you have dropdown.
The method is called Cascading combos.

This has just been asked in another thread

Do I have to make a table of each set of names?

I would just have a table with first combo values in first field and second combo values in a second field in just the one table.

[jojowhite]

see Sheet1.
A and B column has data validation on them.
sheet "data" holds the valid selection.
check out the Named range (Ctrl-G, to see) used in Indirect() function.

[Welshgasman]

see Sheet1.
A and B column has data validation on them.
sheet "data" holds the valid selection.
check out the Named range (Ctrl-G, to see) used in Indirect() function.

I thought they were talking about an access form?

[jojowhite]

ooops, wrong attachment sent.
here, open Form1.
suggest you read some ms access programming books to fully understand
what you are doing.