Cascading combos, continuous or datasheet

[spikepl]

I've dissected CJ_London's Cascading Combos from here:

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

Been fiddling with it for ages, but have not been able to make it do a simple thing.

I need a setup, where an unbound column (1) of Combo1 is shown, and restricts Combo2, which shows its unbound column (1)

tblEmployers
---------------
EmpID PK, autonumber
EmpName


tblPositions
-------------
PositionID PK, autonumber
PositionName
EmpID FK


Data:


tblEmployers
---------------
1, TheFuzz
2, TheMob


tblPositions
-------------
1, BeatCop, 1
2, Inspector, 1
3, Chief, 1
4, Footsoldier, 2
5, Capo, 2
6, CapoDiTuttiCapi, 2

I need to show this in a datasheet (or perhaps continuous, if need be) view:

TheFuzz BeatCop
TheFuzz Inspector
TheFuzz Chief
TheMob Footsoldier
TheMob Capo
TheMob CapoDiTuttiCapi

where each item is selectable, and choices in column 2 are restricted by choice in column 1. (and yes, I could go back to the standard continuous-form fiddle with textbox in front of the second combo, but perhaps someone has cracked CJ_London's solution for datasheet )

 

[CJ_London]

Spike - as explained in the notes, this only works with bound controls for continuous or datasheet forms.

Note that for both these techniques to work in a continuous form or datasheet view, all the comboboxes need to be bound (in order to retain the values selected for each record). Used in a continuous/datasheet form in dataentry mode or a single form, they do not need to be bound.

I guess you could modify it to work off a disconnected adodb recordset

 

[spikepl]

What makes you think that I cannot read and made the combos not bound?


Update: actually, never mind - I really need to move forward so I use the textbox in front trick, so do not do anything.

 

[CJ_London]

Perhaps I misunderstood

What makes you think that I cannot read and made the combos not bound?

I need a setup, where an unbound column (1) of Combo1 is shown, and restricts Combo2, which shows its unbound column (1)