Row source of combo box

[Chi]

Hi,

I have a combo box so that the users can choose the data (Sue, Lisa, Sheila
or Teri) from the drop out list. I created a new form named TEACHER
INFORMATION attached next to the drop out list for them to enter new names if
they don't see the names they want to use on the list. I have to close the
database in order to see the new names appear in the drop out list.
Would you please show me how to add the new names that entered by the users
to the row source of the combo box with out close the database?

Thank you so much!
Chi

 

[Jeff Boyce]

Chi

The combobox is filled when the form opens. If you add (or update)
information in the underlying table(s), the combobox doesn't know about the
changes. Try using .Requery on the combobox after the change.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Chi]

Hi Jeff,

Thank you so much for your response! It works perpectly!!