data type error

[roshawn]

I have an error message when I go to the switchboard. I
have a commnad that links to a report, and it will
say "There was an error executing the command". So than I
go to the actual reports page and try to click on it, it
will say "datatype mismatch in criteria expression". Has
anyone got this error. after making changes to the data
type. Thank you in advance.

 

[Van T. Dinh]

The problem is most like in the criteria clause of the Query (or the SQL
String) you used as the RecordSource for the Report/SubReport (if
applicable) that you are trying to open.

If you cannot find the error in the Query / SQL String, post relevant Table
details and the SQL String (of the Query).