Change I change a Form's Name...?

[Guest]

I have a form that I created and I would like to change it's name but it is
linked to 100s of queries and reports and I don't want the whole thing to
"blowup". Before I changed the name, can anyone tell me if by doing so I
will break the link to all the other objects that reference this form...?

Thanks,

Rebecca

 

[Jeff Boyce]

Yes.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Richnep]

I have a form that I created and I would like to change it's name but it is
linked to 100s of queries and reports and I don't want the whole thing to
"blowup". Before I changed the name, can anyone tell me if by doing so I
will break the link to all the other objects that reference this form...?

Thanks,

Rebecca

Hi Rebecca,

YES YOU WILL BREAK THE QUERIES! That is my biggest pet peave about
access, one typo and you you gotta go change queries, forms and the
like. If you have queries built off other queries, it can be a
nightmare. good luck

 

[Douglas J. Steele]

Hi Rebecca,

YES YOU WILL BREAK THE QUERIES! That is my biggest pet peave about
access, one typo and you you gotta go change queries, forms and the
like. If you have queries built off other queries, it can be a
nightmare. good luck

Look at 3rd party products such as

Find & Replace: http://www.rickworld.com/products.html
Speed Ferret: http://www.moshannon.com/speedferret.html
Ucora's: http://www3.bc.sympatico.ca/starthere/findandreplace/