Text box look at a different table

[SteveC24]

Hello,

I have a form which is all setup to look at a table called "tblChem". I would like to add a single text box that looks at a value in a table called "tblMeasures".

I know it seems like an incredibly simple question, but it has got me! I have put the following into the Control Source of the text box:

=[tblMeasures]![tempmeasure]

There is only ever 1 record in that Measures table, whereas there may be many in the chem table.

Why does it just come up with "#Name?" ???

I would rather avoid a query, but will have to if no-one can come up with a better idea.

Thanks in advance!

 

[sukhi]

why dont u use DlookUp function to read value from measures tables (may be in form's OnCurrent/OnLoad function) and update the field in form.

 

[SteveC24]

Thank You

Thank you! Just what I needed!

For anyone interested, this is what I used: (in the control source of the text box):

=DLookUp("[tempmeasure]","tblMeasures")

Thanks again!