How to update a second combo from another combo within the subform

I,m getting a mix up here how to update the second combo within the subform in Ms Access from another Combobox.I keep on getting an error:

Private Sub CboManual_AfterUpdate()
Me.Description.Column(1).Value = Me.CboManual.Column(2)
End Sub

Open in new window

test.laccdb

Kyle Abrahams, PMP

So the access columns are multi column comboboxes by default, but you can still have only one value (which it references off of the bound column).

To set the combobox, all you need to do is assign the combobox to the corresponding value.

EG:

Me.Description = Me.CboManual.Column(2)

Open in new window

This is of course assuming that Description's bound column is Column 2 of the cboManual.

Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.Sc

ASKER

To set the combobox, all you need to do is assign the combobox to the corresponding value.

EG:

Me.Description = Me.CboManual.Column(2)

Open in new window

I have tried that it also failed

Kyle Abrahams, PMP

So what is your bound column for the Description? And what are you passing in?

Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.Sc

ASKER

Ok here is my small database for you to try it.

Regards

test.accdb

ASKER CERTIFIED SOLUTION

John Tsioumpris

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial