Roger Carlson as an SSDB (Small Sample Database) at his site http://www.rogersaccesslibrary.com/TableOfContents3.asp#C. Look for cascading combo boxes.
Signature
Duane Hookom MS Access MVP
> How do I set up a series of combo boxes so that when I make a selection in > the first field, it narrows the choices in the second field?