Adding new value to Combo Box

[mapat]

hello,

I have 10 combo boxes on a form looking up at the same table (fileld A). I want the user to be able to enter a new value (that's not in the table and therefore neither it is in the combo box) to the 1st combo Box (let's say) and that same value to be automatically added to the table, so when I use the next (2nd one) combo Box, that same value is already in the table.

How can I do this??

Thank you very much

 

[boblarson]

Use the Not In List event to open a form to add the info to the table and in the form's On Close event put

Forms!YourFormNameWithTheComboBox.YourComboBox1NameHere.Requery
Forms!YourFormNameWithTheComboBox.YourComboBox2NameHere.Requery

of course changing the names to the appropriate object names in your database.