combo box in form does not match table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a combo box in a form that was created from a combo box in a table.
if i change the combo box values in the table, how can i update the form to
match the table without recreating the form combo box?
 
You can delete it from the form, then re-add it. What is defined in the
table is basically the default.

Generally speaking, your combo-boxes should use a table or query as their
source if the values will be changed or updated. You don't wnat to go in
and maintain this list every place you have put he box.

Hope that helps,

Rick B
 
As Rick suggests, basing your combo box on a table or query ensures that
changes to the rows show up. You didn't mention how your "combo box in a
form" was "created from a combo box in a table".

Does this mean you are using a lookup data type definition in a table? If
so, this could be causing confusion, as what is displayed when you look in
the table is NOT what is stored in that field.
 
Back
Top