VBA Coding

[chris11590]

I am trying to create a cascading box. first time i am attempting to do an after-date code. i read post about cascading list and attempt to plug in my tables into the code. no luck.

if i select branch from tblebranch( combo box 10) i want to select a Group Sector from a dependent tbleGroupSector combo box (combo 4).

can anyone help?

 

[dkinley]

Perhaps the demo on this thread will assist you ...

http://www.access-programmers.co.uk/forums/showthread.php?t=155389

If not, please post back.

-dK

 

[chris11590]

im sorry. i look it just seems very complicated. all i need is two combo boxes to be independent of one another.

 

[dkinley]

I am trying to create a cascading box ... from a dependent tbleGroupSector combo box ...

... i need is two combo boxes to be independent of one another.

Okay, now I am confused as to what you really want. This link ...

http://www.techonthenet.com/access/comboboxes/index.php

is a tutorial on combo boxes. It may or may not help you decide on what it is you really want. Worst case, it may simplify what you think is complicated by walking you through the process. I will testify that even after creating 100s of combo boxes, it can still sometimes throw your head for a loop but a solid understanding will help clear up cloudy thoughts.

Worst case, take a look and see if does anything; if not, I would request that you post your db and tell me what it is you are trying to do.

-dK