Automated Linked Table manager

[YoungManRiver]

All,

I added my auto re-linking code to my "Main Form" init sequence to automatically re-link my linked tables.

However I still am getting errors, before it gets to the code. Looks like I need to link in my code somewhere else to catch the application init instead of the form init.

Where do I do this and how? Was assuming the tools+startup but did not see it there, or maybe I'm blind.

YMR

 

[PHV]

Did you put the code in the Open event procedure of your startup form ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[YoungManRiver]

PHV,

No never had to do this before and code is in class module so normally called with:

Sub Form_Load()
Dim SCRNfields as clsTABLES
Set SCRNfields = New clsTABLES
Set SCRNfields.TargetForm = Me
SCRNfields.Link_TBLs
End Sub

How do I call this in the startup, is there a method or code example of this?

YMR

 

[PHV]

What happens if you move the code from the Load to the Open event procedure ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886