Help on runing a function on db startup

[Allen]

I have a 2000 Access Split Db.I was using some code that
some one had refered to me on this site.
http://www.mvps.org/access/tables/tbl0009.htm for
relinking tables, Now I the the code in a form that starts
when the Db opens and ran the function(fRefreshLinks) on
Load. but it only works if the backend is in the original
location. If I move the backend, I get an error that I
cant find the backend. My Questions is:

Do I need to put that code as a module or leave it on the
form that starts up?

How would I run the function(fRefreshLinks) at Db Start Up
before I get that error, that it can not find the backend.

Thanks, Allen

 

[Wayne Morgan]

If you move the back-end file, you'll need some way of telling the function
where to look for it. Using the function listed below when the error is
received and passing this information to the relink function should solve
the problem.

http://www.mvps.org/access/api/api0001.htm