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

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

Guest

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.
 
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 ...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Form Refresh 1
Updating tables when you input new data 0
Table field name change propogate to queries/reports/forms 1
combining two or more table fields into a single table field 1
Update Two Tables Using One Form Contents 0
After Update Event 3
Null fields on report 3
Trying to add a field from another table on a form 1

Back
Top