Drop down boxes

[Guest]

Is there a way to create two fields, both drop-downs, have 5 drop-downs in
the first field, and when you select one value in the first drop-down, it
would show one of five drop downs with many values in the second field. OK I
have a first drop down this Training, Wiring, Network Wiring, Blah, Blah.
When you select Training in the first drop-down, the second drop down would
show only the training values that you can select from. Or if in the first
Drop-down you select Wiring, and the next drop-down gives you only wiring
values, and so on. thanks in advance.

 

[Rick B]

Yes. This is called "cascading combo boxes". Do a search and read the
previous posts on this very common question and you will find ways to
accomplish this.

Please always search for your answer before posting a new thread.

 

[John Vinson]

Is there a way to create two fields, both drop-downs, have 5 drop-downs in
the first field, and when you select one value in the first drop-down, it
would show one of five drop downs with many values in the second field. OK I
have a first drop down this Training, Wiring, Network Wiring, Blah, Blah.
When you select Training in the first drop-down, the second drop down would
show only the training values that you can select from. Or if in the first
Drop-down you select Wiring, and the next drop-down gives you only wiring
values, and so on. thanks in advance.

You cannot do this in a table datasheet (just one of many, many
limitiations; table datasheets are NOT designed for user interaction
but for data storage). However, it's pretty easy on a Form based on
your table. You need just a tiny bit of VBA code.

Base the second Combo Box (the proper term for a "drop down") on a
query using

=[Forms]![YourFormNameHere]![ComboBoxNameHere]

as a criterion; this will filter the rows displayed in the second
combo to those which match the first.

The code is one line, in the AfterUpdate event of the first combo box.
View the combo's Properties; click the ... icon by the After Update
event on the Events tab; choose Code Builder; and edit it to

Private Sub ComboBoxNameHere_AfterUpdate()
Me!SecondComboBoxNameHere.Requery
End Sub

using of course your actual combo box names.

John W. Vinson[MVP]

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "CascadingCombos.mdb" which illustrates how to do this.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L