Update new values to combo box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chi - 05 Aug 2005 19:33 GMT

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

Reply to this Message

MacDermott - 06 Aug 2005 00:40 GMT

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.

> Hi,
> I have the table named INFORMATiON which has SCHOOL, FIRSTNAME and LASTNAME
[quoted text clipped - 10 lines]
> Thank you
> Chi

Reply to this Message

Chi - 08 Aug 2005 17:41 GMT

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

> 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.
[quoted text clipped - 21 lines]
> > Thank you
> > Chi

Reply to this Message