what could be wrong?...

[jonra]

i wan to open a report from my form...when i click the button to open the report...it gave me a error "Data type mismatch in criteria expression"...whats wrong?...can someone help?...

my code

Private Sub Command12_Click()
On Error GoTo Err_Command12_Click


DoCmd.OpenReport "incident", acViewPreview, , "[ID]='" & Forms![ret]!txtID & "'"

Exit_Command12_Click:
Exit Sub

Err_Command12_Click:
MsgBox Err.Description
Resume Exit_Command12_Click

End Sub

 

[Eupher]

Is the txtID field on the same form as the command button? If so, try Me!txtID instead of Forms![ret]!txtID.

Ken S.

 

[Eupher]

After looking at your code again, it looks like your syntax is correct. I would double-check that the [ID] field is of the same data type as the [txtID] field.

 

[jonra]

thanks eupher..i recreat the form n the form works fine...