Combo box updates

i have changed my lookup field text and have been asked if i wanted to update
all the objects that used the fields which i did but when i opened the
objects in question they are not update untill i choose the changed text from
the dropdown, may i know why that is? obviously i am thinking it should be
updated automatically after the change update in the table itself.

Amin

From your description, it sounds like you have used a "lookup" data type in
a table definition. A scan through this newsgroup will reveal considerable
problems with using a "lookup" field that way.

The preferred approach is to use the underlying data type (long, text, ...)
of the looked-up value, to NOT use tables for data entry/edit, and to use a
combobox in a form to do your looking-up.

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Amin" wrote in message
...
i have changed my lookup field text and have been asked if i wanted to
update
all the objects that used the fields which i did but when i opened the
objects in question they are not update untill i choose the changed text
from
the dropdown, may i know why that is? obviously i am thinking it should be
updated automatically after the change update in the table itself.