Adding Combo Box Access 2003 - problems

[gtmtnbiker98]

I have an existing Access 2003 database. Trying to add a new field in an
existing database and wanting to add a combo box in the main form to link to
the new field in the database. After creating the combo box, my new field
does not appear when trying to link the Control Source. I have this combo
box configured to look up values in a table that is working fine, but my
combo box is currently unbound due to the fact that the new field that I
added is not showing up in Design View in order to be linked. What am I
missing? Please help.

 

[Douglas J. Steele]

Check the RecordSource of your form. Odds are it's an SQL statement that
explicitly lists which fields are included (or a query that does the same).

 

[gtmtnbiker98]

Thanks, that did the trick. Wonder why it caches the fields instead of
updating when the tables are modified? Oh well, it's fixe and I'm happy.