>>Unfortunately I didn't post all of my original message regarding the environment. I'm adding this custom form off of the Visual AccountMate (SQL version) menu. Everything is already connected via a 32bit ODBC System DSN connection that Visual AccountMate sets up. I copied an existing form, changed my remote view and added my new fields. I have no idea why it is asking me to give my SQL login and password.<<
A couple of things to check,
a) ensure the view is set to use shared connections
b) if no "view" already has the connection in use (you are opening the 1st table on the connection) you will be asked for a sql login (if no trusted connection)
if b) is true, then you will have to supply a login and password to sql*server. The only way around this (that i know of besides trusted connections) is to capture the login and password of the user into global varibales (oops-application variables )and then force that into the connection via the =DBsetPROP("YourConnectioName", "Connection", "userid",lcUserId)
=DBsetPROP("YourConnectioName", "Connection", "password",lcPassword)
commands.
Kevin