Microsoft Access 2003 Run Time Error 2585
Posted on 2012-04-05
I am using this code to prompt adding a user to the database
If Me.thisuser <> Me.cboEmployee Then
Dim strMsg As String
strMsg = "New User Prompt "
strMsg = strMsg & "Do you wish to be added as a new user? "
strMsg = strMsg & "Click Yes to Save or No"
If MsgBox(strMsg, vbQuestion + vbYesNo, "New User? ") = vbYes Then DoCmd.OpenForm ("frmnewrec")
I want to close frm logon and open frmnewrec but get that runtime eror 2585 while trying to close. The code is in the on current field. I have tried the activate but no help. Be gone for the weekend but will be checking. Thanks for the help.