#NAME? Error

[sunny441]

Hello guys!

Not sure if this is in the right place! I am working on an Access db. As the topic says - I am having problems with retrieving data from a table and displaying.

The one table has the component information like manufacture name, size and other things. The other table has some information pertaining to Temperature (mostly numbers here). On this 2nd table there are some fields that have no value and have been set to "---" by the previous db guy. All the fields are set to TEXT value.



Now on the final front end/form - which displays information, the information from the first table shows up just fine. All the temperatures and info from the 2nd table show up as #NAME? Error.

Any ideas as to what might be wrong? I have the table sources set to the right values (like =[temp rear]). I also tried changing the field from TEXT to Number. But that did not help. The relationship is correct and the keys are correct.

I am at my wits end! Please help!!

[TheShabz]

(like ([temp rear])) i think might fix things.

[sunny441]

tried that already!

No luck with that.