Cascading combo-boxes in table form (1 Viewer)

T

Takunda Mafuta

Registered User.

Local time

Yesterday, 18:22

Joined

Sep 4, 2019

Messages

13

• Sep 4, 2019

• #1

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}

 

Attachments

• 
  tabular comboboxes.PNG

  8.7 KB · Views: 54
• Cascading comboboxes that are in a tabular form.accdb

  528 KB · Views: 60

Last edited: Sep 5, 2019

I

Insane_ai

Not Really an A.I.

Local time

Yesterday, 21:22

Joined

Mar 20, 2009

Messages

264

• Sep 4, 2019

• #2

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

You've got your good things, and you've got mine.

Local time

Yesterday, 21:22

Joined

May 21, 2018

Messages

8,527

• Sep 4, 2019

• #3

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

 

Last edited: Sep 4, 2019

mike60smart

Registered User.

Local time

Today, 02:22

Joined

Aug 6, 2017

Messages

1,904

• Sep 4, 2019

• #4

Hi Can you upload a zipped copy of the database?

 

theDBguy

I’m here to help

Staff member

Local time

Yesterday, 18:22

Joined

Oct 29, 2018

Messages

21,467

• Sep 4, 2019

• #5

Hi. Is your combobox bound or unbound?

 

bob fitz

AWF VIP

Local time

Today, 02:22

Joined

May 23, 2011

Messages

4,721

• Sep 4, 2019

• #6

Takunda Mafuta said:

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.

Click to expand...

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

 

Attachments

• CascadingComboInSubform2k.mdb

  388 KB · Views: 73