updating typed list lookup controls on forms

[Peter Baldwin]

Hi,
I have a couple of relatively short lists that I simply entered as typed
lists in a lookup field rather than creating a relationship to another table
storing the values. As usual, my first attempt needs revising. I can easily
modify the list within the 'lookup' tab of the field's 'data type' in the
table itself. Is there an easy way to make controls on forms that were
created with this former list now use the new updated version, or do I have
to manually re-insert the control to make it update?
Many thanks
Pete

 

[Albert D. Kallal]

Hum, yes...you do have to re-do those controls.

Of course, once done, then it is a simple matter to add more records to
those tables..and your combos and listboxes will then show the new values.
So, from a flexibility, and maintenance point of view..the efforts are well
worth it.

And, when you do get those other tables built, I would as a rule try and
avoid using the "lookup" feature in the table design view. While when first
staring out, the table lookup feature seems nice...it tends to bite you..and
cause a lot of problems down the road.

So, in place of using the lookup feature at the table, you simply use the
combo box wizard when making a form.

You can read some comments and notes here about this here..(pay attention to
#2)..

http://www.mvps.org/access/tencommandments.htm

What the above means is that you can, and should have all kind of tables,and
relatons, and even use combo boxes to lookup to those other values, but the
suggestion simply means to advoid using the table lookup feature.