In most cases, if you change the name of a form, that will propagate throughout Access. However, you might run into issues in formulas and aliases within your queries, forms, and reports. And, if there are VBA or Macros, those may need to be manually edited.

Richard has a video Object Dependencies that talks about this and he goes further in Access Expert 2.

The easiest way to find out is to back up your database then try changing the name and see what does or doesn't work.

Don't forget if it has VBA you will get to go through the code and change things by hand. Oh if the database is split you may have to change things by hand as well (at least I had to).

You can use VBA Editor's Find & Replace to update form names en masse across all modules.  If form names are used in SQL statements of queries, you may use VBA to loop through all the queries in the QueryDefs object and change each of their SQL statements.  It's also a good habit to avoid using explicit form names if you can.  For instance, in VBA, use Me.Name to refer to the form name instead of using its explicit name.  In a parameter query, use VBA to insert the value of the parameter instead of explicitly referencing the form (i.e. Forms!MyForm!MyControl) as the parameter.

@0[Dave-ANDERSON]

Backup your database before you make any changes!!!!!!

-Raymond

Just wanted to say "Thanks" to those who took the time to respond to my visitor question.  I do appreciate that effort on your part.

There are tons more benefits once you become a member. I strongly encourage you to join. Silver level is incredibly low cost.

My users are THE BEST. :)

Richard we have the best role model :)