Data Type Mismatch in Criteria Expression
Posted on 2007-10-07
I am running a Microsoft Access Program and when it is getting an error. I take one form, I select a record, hit a button and it opens another form with the information so that I can edit that record. I get the error that states the following before the new form is opened:
run time error '3464' Data type mismatch in criteria expression
Here is the code in that block where the error is and it puts an arrow focus on Me.FilterOn = True:
Private Sub Form_Load()
Me.Filter = "ProjectID = '" & Me.OpenArgs & "'"
Me.FilterOn = True
If Me.OpenArgs = "" Then
DoCmd.GoToRecord acActiveDataObject, , acNewRec
What could be the problem?