Query property

[Max]

When I run a macro, screen gets populated and asks for UserID and Password,
dut ot ODBC?
How Can I use the send keys Action in this macro to enter my user id, tab,
enter my password and then press enter to continue.

I aslo tried to use the SourceConnectStr property in the query design veiw;
I put this code: ODBC;DSN=MyDSN;UID=MyUserID;PWD=MyPassword;DATABASE=NameofDB;

But it gives me this error [ODBC--Connection to 'MyDSN' failed]

Please help

 

[Wayne-I-M]

Private Sub Button_Click()
On Error GoTo Button_Click_Err

Forms!Form1!UserID = "MyID"
Forms!Form1!Password = "MyPassword"
DoCmd.GoToControl "NextBox"


Button_Click_Exit:
Exit Sub

Button_Click_Err:
MsgBox Error$
Resume Button_Click_Exit

End Sub



Add this to an event ( On Load, On Activate, or some other event). Change
the "MyID" and "MyPassword" text to whatever you use. As you can see I have
shown the event as the On Click event of a buttton called "Button". All my
objects are in a form called "Form1".