Error 2174 you can't switch to a different view at this time

Run time error 2174

Error 2174 you can't switch to a different view at this time occurs we tried to switch between views. Error 2174 occurs, if you are debugging code, you must end the debugging operation before switching views. In this article we are explain the reason of error 2174 error. Suppose we are open a form, by default its open in form view. But if we want to change the form view to datasheet view, then we have to use macro code to open same form with datasheet view. After write macro, when we open the form, the run time error '2174', you can't switch to a different view at this time as shown in Fig 1.1.

Error 2174 you can't switch to a different view at this time Fig 1.1

Fig 1.1

Resolution: We can avoid this error by using error handling techniques. Or we have to set property sheet values. We have to allow datasheet view Yes and allow Form View to No. So using this we can avoid the error. And also we don't need to write code for that because it's already in datasheet view.

To reproduce error we have to allow Form view Yes and on open event, write macro for open same Form in datasheet.

VBA code On Open event:

Private Sub Form_Open(Cancel As Integer)
DoCmd.OpenForm "Form1", acFormDS
End Sub


DISCLAIMER

It is advised that the information provided in the article should not be used for any kind formal or production programming purposes as content of the article may not be complete or well tested. Access Guru will not be responsible for any kind of damage (monetary, time, personal or any other type) which may take place because of the usage of the content in the article.