I have a database that has been running well for over a year.
I am now getting the following error when clicking button to View Report; Microsoft Visual Basic, Run-time error '3464', Data type mismatch in criteria expression. The following is the code for viewing report when button is clicked.
Private Sub VIEW_SQ_FT_LN_FT_EA_ITEMS_REPORT_Click()
Me.Visible = False
strWhere = "[Property Number] = " & Me.[Property Number]
DoCmd.OpenReport "SQ FT/LN FT ITEMS REPORT REV ADMIN", acViewPreview, , strWhere
DoCmd.ShowToolbar "Ribbon", acToolbarNo
End Sub
Any suggestions? Thank you for your help in advance.