Type mismatch in expression

[Dollar]

Frenz,

I am getting the above error when i try to open my report. My parent table
(in current database) is linked to another data source table (another
database).

I have a form which is linked to a table which holds records of only the
form itself. In the form one of the fields is a drop down list linked to the
parent table (in current database).

My report is a combination of the above form data and the data from the
parent table extracting its data on basis of the drop down field in the form
& associated data.

Plz help me solve the above error

Thx Dollar

 

[BruceM]

Your information is a bit vague. What do you mean by "a table which holds
records of only the form itself"? Do you mean it is an unbound table, or
what exactly?
If the report is bound to a query, do you get the error message if you open
the query directly? If the report is bound to a table, it could be there is
code for a filter, etc. that is causing the problems, or a domain function
such as DCount with a faulty criteria expression, or maybe something in the
report's Sorting and Grouping conditions. You will need to provide some
specifics about the error.

 

[Golfinray]

A type mismatch means that you are trying to do something on one data type
when it calls for another data type. You may be trying to open date or time
formats when the program is expecting text.