Access 2000 - Open external table

I have been using the on click function
=fOpenRemoteForm("H:\reportV3.mdb","main")which worked fine. Suddenly
nothing happens. Can anyone shed any light on this or suggest an
alternative. Thanks

re: Access 2000 - Open external table

what happens when you compile your code? do you get errors?
Do you see any references listed as MISSING when you check for them?

Sorry, but I'm having a hard time guessing what's wrong with your code
without you actually posting it for me to see... I guess my psychic
powers aren't what they used to be....

re: Access 2000 - Open external table

Tiga wrote:[color=blue]
> I have been using the on click function
> =fOpenRemoteForm("H:\reportV3.mdb","main")which worked fine. Suddenly
> nothing happens. Can anyone shed any light on this or suggest an
> alternative. Thanks[/color]

Put a breakpoint at

If Len(Dir(strMDB)) Then

Regarding calling ShowWindow twice:

The win32 helpfile under the STARTUPINFO structure explains why the
second call to ShowWindow works. Further investigation can be done
using the GetStartupInfo API function.

James A. Fortune