Hi I am very new to VBA, and I am receiving an error I am not sure how to resolve. I have a form set up so that when I click on a box it opens a form that allows me to search employees. I just switched from Access 2010 to 2013 and when I click on the box the form no longer opens. I have attached the code that I use. The code opens up various boxes to add new team members, search, etc. How do I resolve this error so I can use the search function again?
[Private Sub btnCSat_Click()
DoCmd.OpenForm "frm_CSatTeam", acNormal, , , acFormPropertySettings
End Sub
Private Sub btnExit_Click()
'DoCmd.CloseDatabase
DoCmd.Quit
End Sub
Private Sub btnNewMember_Click()
DoCmd.OpenForm "frm_TeamMember", acNormal, , , acFormAdd
End Sub
Private Sub btnRefresh_Click()
sfmTeamMember.Requery
End Sub
Private Sub cmbRegion_AfterUpdate()
'sfmTeamMember.Form.Filter = "Region = " & Me.cmbRegion
If sfmTeamMember.Form.Filter = "" Then
sfmTeamMember.Form.Filter = "Region = '" & Me.cmbRegion & "'"
Else
sfmTeamMember.Form.Filter = sfmTeamMember.Form.Filter & " AND Region = '" & Me.cmbRegion & "'"
End If
sfmTeamMember.Form.FilterOn = True
End Sub
Private Sub btnRecords_Click()
DoCmd.OpenForm "frm_TeamMember", acNormal, , , acFormEdit
End Sub
Private Sub btnSearch_Click()
DoCmd.OpenForm "frm_Search", acNormal, , , acFormEdit
End Sub]
Thank you!