Have a program in Access 97 that I am distributing. Some users may not have the DSN set up on their machines so I created a function to do that. I have it set to show a form on start-up, a form that is connected to a database using a particular DSN. In the form's error event I am able to use my function and successfully create the DSN, however, it doesn't continue opening up the form.

I've tried explicitly calling the open form event and doing a DoCmd.OpenForm...neither works.

In the form's error event I am setting Response = acDataErrConinue