Carlos,
Yes, There are two databases and I just tried your suggestion.
It seems like no matter which way I try to do it; DBSETPROP to change the Connection String, or Open the DataBase depending upon Production or Test, The result is the same:
The Wizard generated form seems to "remember" the database that was selected during the generation process and no matter what I set the connection to or which database I open, the form processes data from the connection/database at generation time.
I need to find out how that can be over-ridden at run time.
Your good ideas got it this far and I thank you for that. Please advise if you have some ideas on this re-definition of the problem.
Kindest regards,
Bob Pahus
Fort Worth Texas
Thanks,
Bob Pahus
Gainesville TX