Set combo box selection in code

  • Thread starter Thread starter mscertified
  • Start date Start date
M

mscertified

When you set a multi-column combo box value in code, is it sufficient just to
set the bound column or do I have to set all the columns? I only know the
bound column value and I'd prefer not to have to do a table lookup. Thanks.
 
The bound column is the only one that will respond to

Me.MyCombo = SomeValue

When that is set, the other column values will be the values for the
selection.
 
The value in the bound column is also the value that will be stored in your
table if the combo box is bound to a field in the forms Record Source.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Retain combo box order 1
combo box - bound column 2
Combo Box Showing only bound column when choice is made -- the new normal? 1
VBA code for unbound column in combo box 3
Locking a combo box 4
How to get the value of non-bound combo box column? 5
How to switch combo boxes? 1
Old and new values of combo box columns. 3

Back
Top