I have a Master Table in a Master DB linked to a few sub databases. The
input forms (to update Master table) are in the sub databases based on
queries also in the sub db's. The field names in the Master table change
names occasionally. Is there an efficient way to update code in modules,
forms, and control/fields in the form(s) when the fields change in the Master
table. I can update the control source/fields in the form for the new fld
names - but I noticed the old/previous field names still in the dropdown
window (at top left of Font window). Also do I have to update all field
names in the code/modules and re-insert new fields on form? Am I doing
un-necessary/extra work when the field names change or is there a more
efficient way to update or plan for field name changes?

Steve,

Though I am slightly confused by your meaning of *sub databases* I think
this will work for you... http://www.rickworld.com/products.html (Sorry
don't know of a free one that actually works).

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Steve Stad" <(E-Mail Removed)> wrote in message
news:704F8374-F7E6-43A5-BF7A-(E-Mail Removed)...
>I have a Master Table in a Master DB linked to a few sub databases. The
> input forms (to update Master table) are in the sub databases based on
> queries also in the sub db's. The field names in the Master table change
> names occasionally. Is there an efficient way to update code in modules,
> forms, and control/fields in the form(s) when the fields change in the
> Master
> table. I can update the control source/fields in the form for the new fld
> names - but I noticed the old/previous field names still in the dropdown
> window (at top left of Font window). Also do I have to update all field
> names in the code/modules and re-insert new fields on form? Am I doing
> un-necessary/extra work when the field names change or is there a more
> efficient way to update or plan for field name changes?