Cascading combo-boxes in table form

[Takunda Mafuta]

Hie I have created a tabular form and I inserted second column with combo boxes which are dependent on combo boxes in the first column. However when I select a combo-box value in the next row of the first column, instead of updating just the combo-box of that very row in the second column, it is updating the whole of the second column. See the attached image and kindly assist.
{the subject form is entitled PRF section C}

 

[Insane_ai]

Can you post the code used to update the combo boxes please? It would help us find the error. Also, please verify the names of the combo boxes; it looks like you may have copied and pasted them so they may all be named the same thing causing this to happen (just a blind guess)

 

[MajP]

That is normal behavior. See a possible work around.
https://www.access-programmers.co.uk/forums/showthread.php?t=275155&highlight=cascading+combo

 

[mike60smart]

Hi Can you upload a zipped copy of the database?

 

[theDBguy]

Hi. Is your combobox bound or unbound?

 

[bob fitz]

Hie I have created a tabular form and I inserted second column with combo boxes which are dependent on combo boxes in the first column. However when I select a combo-box value in the next row of the first column, instead of updating just the combo-box of that very row in the second column, it is updating the whole of the second column. See the attached image and kindly assist.

If your sub form is in datasheet view then the solution used in the attached db might be used.