Combo boxes, adding to list

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

Guest

I have a form that is being used for data entry. On this form I have a combo
box that I want the user to be able to pick from a list, however, if the item
is not found, I want it added automatically. This particular field does not
"reside" in its own table or query. I want to just have a list maintained as
part of the combo box.

How can this be done ??
 
I have a form that is being used for data entry. On this form I have a combo
box that I want the user to be able to pick from a list, however, if the item
is not found, I want it added automatically. This particular field does not
"reside" in its own table or query. I want to just have a list maintained as
part of the combo box.

How can this be done ??
Click to expand...

Re: >This particular field does not "reside" in its own table or
query. <
What do you mean by that line?
Where do you get the combo box's values from?
 
I have a form that is being used for data entry. On this form I have a combo
box that I want the user to be able to pick from a list, however, if the item
is not found, I want it added automatically. This particular field does not
"reside" in its own table or query. I want to just have a list maintained as
part of the combo box.

How can this be done ??
Click to expand...

With a certain amount of difficulty. "Value List" combos are really
pretty inflexible; you would really do better to use a small table as
the rowsource for this combo box, and then use the Not In List event
of the combo to add the new record as needed. See
http://www.mvps.org/access/search.htm and search for "Not In List" for
sample code to do this.

John W. Vinson[MVP]
 
Back
Top