Default combo box with multiple columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a combo box with multiple columns that I want to set to a default
selection, based on another selection from a combo box on the same form. I
tried setting the value of the combo box in the AfterUpdate event of the
first combo box, but nothing is happening to the control. Any ideas?
 
Is the value you are attempting to set the second combo box to contained in
the bound column? You can only set a combo box value to what's contained in
the bound column.

Carl Rapson
 
What code are you using? The problem could be in the code.

What are the fields in your query for the combo And are you really
trying to set the value or are you trying to set the criteria? If it
is already in the first combo, why is it the value in the second comb?

We need more information to try to determine what you are doing vs.
what you want to do.

Ron
 
Sorry for the confusion. I got it to work by putting another button on the
form. I used the same exact code, except the rowsource for the combobox (I
wanted to set the default for) was being set based on the selection from the
first combobox. I think it may have something to do with trying to do it in
an AfterUpdate event rather than OnClick, although it worked ok for a
textbox. Thanks for all you help, anyway.
 

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

filter on combo box possible? 1
default values in combo box with multiple colimns 1
Combo Boxes - DISPLAYING multiple fields after choice is made 5
sum combo box based on other combo box 2
auto populate text box based on combo box value 1
cant get cbo to stop outputting key# 0
Access Control on subform / combo box requesting parameter 0
Synchronize combo boxes 2

Back
Top