combo box update

[Guest]

I'm creating an address list form which allows me to add an item, an
organization, or choose the org. from a combo box. I want to type in the new
org., complete the record, go to the next record and add the new org., to the
new record by choosing it from a combo box. I am able to add the new item,
however it will only display in the combo box after I enter and return from
Design view. How do I make the new org. appear in the combo box when I enter
the next record.

 

[John Vinson]

I'm creating an address list form which allows me to add an item, an
organization, or choose the org. from a combo box. I want to type in the new
org., complete the record, go to the next record and add the new org., to the
new record by choosing it from a combo box. I am able to add the new item,
however it will only display in the combo box after I enter and return from
Design view. How do I make the new org. appear in the combo box when I enter
the next record.

Set the Combo Box's Limit to List property to True, and use some VBA
code in its Not In List event to add the new record to the
organization table. The Help topic for Not In List gives a pretty good
example of how this is done - post back if you need more help.

John W. Vinson[MVP]