Several Drop Lists Dependant on Mulitple Criteria

[BenBritton]

I am making a product database for work and have 7 different drop down lists.
I need each selection to alter what options are provided at the next. These
are based on random criteria and there is no real consistency.

 

[Allen Browne]

You will need to write code in the AfterUpdate event procedure of each combo
to set the RowSource property of the next one.

Here's a basic example of how it's done:
Limit content of combo/list boxes
at:
http://www.mvps.org/access/forms/frm0028.htm

 

[BenBritton]

Thanks for the reply Allen but I didnt understand the example shown there. I
dont have any worries for two lists as I dont need code to achieve this. Are
you able to email or do you know where I could find a very generic or simple
example (access file) that has three or more dependent lists. Cheers

 

[Allen Browne]

There is not a simpler approach that actually works in any reliable manner.
If you can't follow that example yet, you may have some learning to do
before you can achieve this.

And no: please do not email is directly.

 

[RD]

Try this one:
http://www.rogersaccesslibrary.com/...?TID=389&SID=4ff34384dc31822e2b82d5234zf23b1f

HTH,
RD