I have a form called "frmsurveyviewer" that loads a set of data that has been filtered according to specs on another form called "frmfilterrecordset". A button on frmfilterrecordset opens the frmsurveyviewer, and the following vb code is on on the Load event.
Code:
Private Sub Form_Load()
DoCmd.ApplyFilter "filterviewer", "[day]='" & [Forms]![frmfilterrecordset]![TXTDATE] & "' And [site]=" & [Forms]![frmfilterrecordset]![COMBOLOC] & ""
End Sub
It has been working fine for a couple weeks now, and now it gives this error
Runtime Error 3011: Microsoft Databse Engine could not find object "filterviewer"...
It's true that there is no "filterviewer", but this has been working fine up until now. It still works on my computer, but now anytime I load the database onto another computer, it doesn't work.
Why might this be happening?