combo box not in list

  • Thread starter Thread starter ashley
  • Start date Start date
A

ashley

I have a combo box that is populated by a field (Number)
in a table, but the rowsource is from another table. The
combo box displays the rowsource from two columns from the
primary table(Number, Description). When the user adds a
new Number into the combo box, how can I have the user
also add the Description for the new Number?

Thanks.
 
Ashley,
You can't "enter" or "add" a new combo box value via the combo box
itself. You can only "select" a value from it that exists in the underlying
table/query of the combo box. (combos are really read/choose only)
In order to add another choice to your combo, you'll have to add that
record to the table/query behind the combo... (you called it... "primary
table" (Number,Description))
In that table you'll fill out a new Number, fill out a new Description,
and... the next time you use your Form the combo box, will display your new
Number and Description... along with all the others.
hth
Al Camp
 
I set the NotInList to yes for the combo box, and added
some code for the event procedure. I was able to add a
new Number if it is not in the combo box. What I can't do
is to add the Description along with the new Number I
added. Does anybody know how to do this?

Thanks.
 
Ashley,
"and added some code for the event procedure"
Click to expand...
What event procedure, and what code did you add?
"I was able to add a new Number if it is not in the combo box."
Click to expand...
Sounds like you created a method to add a new number to the table behind
your combo box, but not the description. Why would you not include that
method/code in your post? Without any details as to how you're adding the
number, we can't help with fixing that method to update the description
along with it.

For now, just go to the table that contains the "new" number you added, and
fill in the description field that's associated with that number. That's a
fix, not a solution...

hth
Al Camp
 
Back
Top