Update Form List

[Annie]

Hello,

In my form I have a combo box called Manufacturer that
pulls data from a combo box - value list in one of my
tables.

When I have to add a new manufacturer to the value list I
have to first update my table then delete the combo box in
my form and re-add it from my field list to show the
changes. Is there any easier way to do this, why isn't it
updating it automatically in all my forms?

 

[JohnR]

I would suggest creating a separate table with the names
of the Manufacturers. Then change the combo box source to
Table/Query and populate it from the Manufacturers table.
Then when you add a new manufacturer t the table it will
automatically update the combo box.

If you check the combo box on the forms, the field list is
static. It is populated with the fields from your table
at the time it is created but it isn't linked. By using a
Table/Query instead of a Value list, you won't have this
problem.