Hi,
Is there a simple way in visual basic to customize a combo box to update more than one field on a form? Creating a combo box using the wizard only allows for the update of one field. I tried the following VB code:
Me.name = Me.Combo59.column(1)
Me.ID = Me.Combo59.column(2)
It only recognizes the name column and won't populate the ID. Any ideas?
Is there a simple way in visual basic to customize a combo box to update more than one field on a form? Creating a combo box using the wizard only allows for the update of one field. I tried the following VB code:
Me.name = Me.Combo59.column(1)
Me.ID = Me.Combo59.column(2)
It only recognizes the name column and won't populate the ID. Any ideas?