Update new values to combo box

[Guest]

Hi,
I have the table named INFORMATiON which has SCHOOL, FIRSTNAME and LASTNAME
fields. For SCHOOL field , I make it became combo box by using LOOK UP tab at
table design view.

It works well, but when i entered a new shool name, the new name not show
up in the list.

Please show me to update new values to the School combo box. If I need to
use some codes or macros to do this task. Please show me more details.

Or show me where I can learn to do this.
Thank you
Chi

 

[MacDermott]

Comboboxes directly in a table are generally a bad idea.
It's also generally a bad idea to enter your data directly in the table.
Make a form based on your table, and create the combobox there.
You will have a lot more flexibility to make the form operate exactly as
you want.

Once you are working with a form, you can post further questions back to
this newsgroup.

 

[Guest]

Hi,
I used the Tips for Users of Allen Browne and I could add new values to the
list.
Chi