I am creating a data base for a competition and entries need to be pigeon
holed into a section and a catagory. The Catagory is dependant on the
Section, if in "LIST BOX A" I have sections 1 to 5, my users will select a
section than the catagory from "LIST BOX B". The choices in LIST BOX B will
be dependant on which section the user choses: Section 1 wil have Catagories
1, 2, 3, 4, 5 and Section 2 will have Catagories 6, 7, 8, 9 etc.. I am
trying to prevent users from entering catagories that do not exist in that
section: Section 2 catagory 1. I need to create a conditional valadation,
how do I do that??? Please help!
Rick B - 02 May 2005 21:35 GMT
Do a search. This is called cascading combo boxes.
Asked and answered all the time.
http://groups-beta.google.com/groups?hl=en&q=microsoft.public.access+cascading+c
ombo+box&qt_s=Search

Signature
Rick B
> I am creating a data base for a competition and entries need to be pigeon
> holed into a section and a catagory. The Catagory is dependant on the
[quoted text clipped - 5 lines]
> section: Section 2 catagory 1. I need to create a conditional valadation,
> how do I do that??? Please help!