I thought I had this worked out with an earlier question, but I still don't have a working process.
I am trying to build a process where a connection to an oracle db is built up to the point where the password is needed. At that point, I want a password form to open and ask for the password (I already have the userID), and when the user enters the password and clicks the "Enter" button, the password gets passed back to the function that is building the oracle connection (strACSConnectionACS()), and it sends the connection over to the db for authentication and connection.
When I run it, the password form opens, but the code doesn't stop and wait for the user to enter the password. It tries to connect without the password and I get an error message.
Also, I can't figure out how to get the form closed after the user enters their password.
I've attached my code. If you see what I've got wrong please spell it out for me in detail - I can't seem to get the drift of how this is suppose to work.
Thanks, Lynn ACS.txt