Will adding or editing fields in my table mess up my forms?

[NotaryEtc]

I have already made my forms, some are bound to queries, some are bound to tables. I realized that I want to add more fields to my tables and delete a few. Is this going to mess up my forms? Is there something I need to do FIRST to make sure it doesn't mess up my forms?

[pbaldy]

No, just make the table changes, then fix the queries and then the forms.

[ipisors]

The way I understood your question, the short answer is "Yes, if the fields you are deleting/renaming are either referenced in the queries that serve as the form's Recordsource, or if a table, then only if that table column is represented on your form by a control whose controlsource is set to that table field.

There is a feature in Access called Name Auto-Correct, and if you have that on, it may automatically do some corrections. However, it is very strongly recommended NEVER to leave that feature turned on when building a new database, so hopefully you have it turned off.

As Paul said - There isn't much you can do other than make the required table changes and then see what needs fixing.

You could run a VBA procedure to print out the names of queries, rowsources and recordsources / controlsources that utilize the field names you are changing. Doing that would come to mind if I were you; it may well help (obviously only if done prior to making the changes).

[Missinglinq]

As Paul suggested, it is the Forms that are based on Queries where this kind of thing frequently goes awry. Fields are added/deleted from Tables but aren't added/deleted to the Queries involved, and hence not available to the Forms based on these Queries. The same thing applies if you have Comboboxes/Listboxes based on Queries/SQL Statements.

Linq ;0)>