Hi All

Hoping this is possible.

I'd like to be able to change what data is show in a combo/dropdown list in a cell based on the value of another combo in same row. Then if the user selects another row, the combo in said column changes based on that row.

For example, lets say i have columns called 'ID', 'Type' and 'Contact'.

'Type' is a list of say contact types, eg. 'Plumber', 'Decorator', 'Electrician'

Based on what is selected for that row, I'd like 'Contact' to also be a combo but filtered to only show say 'Plumber' contacts if that is what was selected for that row. Then on the next row, I can change it to 'Decorator' and contact dropdown only shows 'Decorator' contacts.

I can setup the columns with static combo's no problem with: Combos.Add("cboTradeTypes") and for the grid

.ColDefaultCell("TradeType")
.eType = igCellTextCombo
.sCtrlKey = "cboTradeTypes"

but i have no idea where to begin to allow them to change. I'm assuming it could be under the 'CurRowChange' event for the grid to change the data, but i'm really not sure.

Any help is appreciated

Also, complete side note, is there a way to add a command button. I did find an example for VB6 but this obviously doesnt work in MS Access.

Thanks

Phill

Look at the 'One-to-many combos' sample in the iGrid extra samples library here:

https://10tec.com/activex-grid/extra-samples.aspx 

Is it what you are looking for?

Look at the 'One-to-many combos' sample in the iGrid extra samples library here:

https://10tec.com/activex-grid/extra-samples.aspx 

Is it what you are looking for?

Can't believe i missed that example, I went through them as well 😞. I think that is exactly what I'm looking for. I've only skimmed the form it at the moment but i think thats it. I'll let you know if there are complications, otherwise thank you for the answer :)