How do I refresh/update field names for a form or report?

M

Modeen

If I need to go to a table and modify a field name, how can I then update any
forms or reports I have that are associated with that table so that they use
the new name. It seems that there should be a way to update the field names
in the forms and tables without having to do it manually.

I appreciate your help.
 
V

Van T. Dinh

There is a Name Auto Correct option for the database but you need to set
this before you change the Field name. In addition, the Name Auto Correct
actually doesn't work properly and creates a few unexpected behaviours.
Hence, I disabled the Name Auto Correct option in my databases.

You need to change the Query (if the Form is based on the Query) and the
ControlSource of the relevant Controls on your Form.

There may be some third-party tools that can do this for you ...
 
Top