Help!

[EjS]

Question: I have made several tables, with forms that correspond to the tables. I need to change/update the tables and am wondering if there is a way to automatically have the changes reflected on the corresponding forms. I've wasted time re-doing the forms to match the tables. Any suggestions?

Thank you!

 

[[nateobot]]

As far as I know you cannot automatically update the form with the new table fields. Access is not going to know that you had field [CompanyName] but now it is going to be known as [CompName].

I would just make sure that this is how your tables are going to be known from here on out and that your table structure is set before you start with the forms. Otherwise you will be doing the same thing in a little while when all your tables change again.