Data type mismatch error

[Gerdagan]

Hi all,

I was wondering if you could help me with my error.

I have searched for a response, but I can't figure anything out for my specific problem.

I have set up a query, called 'Pending_calibration_EST'.

This query is to show me records that are pending action by my team, for a particular supplier.

In the status field my criteria is "Returned (Pending)". This works fine, and only shows records that are pending.

However, when I try to specify the supplier in the criteria field i.e. "Supplier Alpha" the error message below appears when I run the query.

Data type mismatch error in criteria expression.

I just can't figure this out, and it is driving me potty. The 'supplier' field is sourced from a lookup from another table, is this what is causing the problem?

Many thanks guys, Gerdagan

 

[boblarson]

Have you been naughty and used lookups directly in table fields? If so, this could be causing your problem. Read this for why.

 

[Gerdagan]

Yeah, I used the look-up wizard in design view of my tables! I don't know how else to do it! I've read through that document, I suppose it's typical MS to install a tool that isn't wholely compatible with itself! Do you know of any good links to help me form these look-up relationships without using the wizard?

Thanks for the super fast reply.

 

[boblarson]

You use lookups at FORM level, not at table level. You can set them initially to help with creating your forms (because then combo boxes will automatically be placed on the form instead of text boxes and making you change them) but you should remove the table level lookups right afterwards.

See here for how to do that:
http://www.btabdevelopment.com/ts/removelookups

Also, putting lookups on table fields does not set relationships. That is done via the Relationships window.

 

[Lifeseeker]

You use lookups at FORM level, not at table level. You can set them initially to help with creating your forms (because then combo boxes will automatically be placed on the form instead of text boxes and making you change them) but you should remove the table level lookups right afterwards.

See here for how to do that:
http://www.btabdevelopment.com/ts/removelookups

Also, putting lookups on table fields does not set relationships. That is done via the Relationships window.

hi Bob, could you please help me with this one? Please see the attached

I have followed the steps above, but I keep getting no results on my report. The operation status is the look up in this case. However, it keep saying the expression is typed in incorrectly, or the expression is too complex to be evaluated.....

I have only two combo boxes on my form to pass the parameter into query. I have doubled checked the parameters, but the report gives me nothing...

The sample query I"m testing is...give me records in where both lab and scs are open. The query just doesn't run...

Please give me some direction on this please.

Thank you

 

[boblarson]

I already answered you in your other post.