Udate Lookup

[Guest]

I have created a list in a lookup. When I try to update these in the table it
works but the forms that I have created do not see the update. So the
dropdown in my form only shows the old list and not the new one that is in
the table.

Please tell we there is a way to refresh the data. I don’t want to go and
redesign all my forms each time there is a change in the list.

 

[Allen Browne]

After you execute the update, requery the combo/list box, e.g.:
Me.Combo2.Requery

 

[Pat Hartman]

To avoid this problem, use tables to store the value lists rather than
storing them in the list itself. You would create a relationship between
the "lookup" table and the existing table and enforce RI. That will ensure
that only valid values get saved. Your combo's RowSources would then be
based on queries that select the data from the "lookup" table and sort it.
The combos will always be in sync since they all get their data from the
same table.

In newer versions of Access, Access propagates changes like this if you want
it to. So, if you change the table, Access asks you if you want to change
any related objects.