Cascading Combobox in Same Datasheet View/Subform

[kelvin2088]

Is there anyway that we can do cascading combobox in the same datasheet view of subform? Basically I'd like to filter "Account Name" based on "Plan#" selected in the same record of subform.

 

[kelvin2088]

What i did wasn't working....

 

[spikepl]

All the instances of a given combo only have one and the same row source, so you cannot do what you want for a datasheet.

For continuous form you can do a fiddle: http://www.access-programmers.co.uk/forums/showthread.php?t=223980

BTW: when asking for support in the future, "not working" is meaningless - read my signature.

 

[kelvin2088]

Omg! Great! Thank u so much!!:d

all the instances of a given combo only have one and the same row source, so you cannot do what you want for a datasheet.

For continuous form you can do a fiddle: http://www.access-programmers.co.uk/forums/showthread.php?t=223980

btw: When asking for support in the future, "not working" is meaningless - read my signature.