(Msg. 1) Posted: Tue Sep 02, 2008 2:17 pm
Post subject: Combo box updates Archived from groups: microsoft>public>access>tablesdbdesign (more info?)
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.
(Msg. 2) Posted: Tue Sep 02, 2008 2:47 pm
Post subject: Re: Combo box updates [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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" <Amin RemoveThis @discussions.microsoft.com> wrote in message
news:43ED67E0-D42E-4E57-A1F0-284C12324C52@microsoft.com...
>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.
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office Other