Cascading Combos...

[raghuprabhu]

Hi All,
Having problems with cascading combos.

This is the first set of cascading combs. (two combo boxes in this set)

On Form1 how do I make the combo show what the user has been allowed to input? The first combo box list shows the users and the second combo box list shows the Enquiry/Transaction.

The user list contains 4 users.
loginUser1 CANNOT input neither the Enquiry or Transaction
loginUser2 CAN input only Enquiry
loginUser3 CAN input only Transaction
loginUser4 CAN input Both Enquiry and Transaction.



This is the second set of cascading combos (three combo boxes in this set)

On Form2 the first combo box shows Section, the second combo box shows Category and the third combo box shows the transaction type. The output of the 3 cascading combos should look as shown below.

ALLOWANCES:
Regulars
HDA
HDA5%
LPA
NRP
Bonuses
REG99
OTHER

Reserves
HDA5%
NRP
LPA
OOC
REG99
Bonuses
OTHER
Cadets
Pay Sheets
PORs
OTHER

DEDUCTIONS:
Regulars
COMSUPER
RMO
LPE
POSTAGE DEBTS
REG99
OTHER

OVERSEAS
Regulars
OLA
OTHER
I need help to sort this please...

Thanks in advance
Raghu Prabhu

I have been able to sort this problem.
Please look at CasCombos020310.zip

Thanks

 

[vbaInet]

This could help you:

http://baldyweb.com/CascadingCombo.htm

 

[raghuprabhu]

Thanks to VbaInet for your suggestion.

I have been playing around with a number of dependent combos. I may have arrived at my own unique solution.

Attached is "CasCombos25Mar10.zip" to illustrate my solution. This is working fine for 4 dependent combos.

I have tested with 10 dependent combos and it is still working but getting very slow. Hope to get some feed back.

Thanks to all who have helped me with my Access Learning process.

 

[vbaInet]

It's great you found your own way of reaching your goal.

I would, however, be inclined to follow what was advised in the link. That would speed things up.