Limit ComboBox list by previous ComboBox results

[David]

I'm would like to have several ComboBoxs' when the list change based on the
previous Combobox's results. For Example: ComboBox1=Course ComboBox2= only
the professors that are in the query with specific course listed.
ComboBox2=Exams based on the course and professor from the 2 previous
ComboBoxs'.

Any help would be great, Thank You

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "CascadingComboBoxes.mdb" which illustrates how to do this.
You can find it here:
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=389

--
--Roger Carlson
MS Access MVP
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