Combo box - not in list

[Spencer]

I should have been able to find the answer, I know it is in here somewhere. I
have two combo boxes. The first is cbo_Type. That is driven of an unbound
combo box to the a table, tbl_Type. I have a second combo box, cbo_Item. This
is pulled from a query that has fields Item and Type from table tbl_ItemType,
which is linked in a one to many to tbl_Type. Once I have selected the Type I
have it so the second combo box pulls up all items associated with that type
based on the query. However, I need to be able to add new items under that
type. How do I do this? If I type it in and it isn't in the list is there
someway I can just get the table to add the new item through the query?

Thanks.

 

[Arvin Meyer [MVP]]

I should have been able to find the answer, I know it is in here somewhere.
I
have two combo boxes. The first is cbo_Type. That is driven of an unbound
combo box to the a table, tbl_Type. I have a second combo box, cbo_Item.
This
is pulled from a query that has fields Item and Type from table
tbl_ItemType,
which is linked in a one to many to tbl_Type. Once I have selected the
Type I
have it so the second combo box pulls up all items associated with that
type
based on the query. However, I need to be able to add new items under that
type. How do I do this? If I type it in and it isn't in the list is there
someway I can just get the table to add the new item through the query?

Thanks.

 

[Arvin Meyer [MVP]]

Sorry I sent the first answer while trying to move another window out of the
way.

You have 2 different questions that aren't really related. The first is how
to sync up 2 combo boxes. I have a demo at:

http://www.accessmvp.com/Arvin/Combo.zip

that shows that using listboxes. The same principle, and methods are used.
for the second question, not in list, there is code at:

http://www.datastrat.com/Code/NotInListCode.txt

and a sample application at:

http://www.accessmvp.com/Arvin/NotInListDemo.zip