Text Box won't get Table Field

[ccflyer]

I have a form based on a table called "WellData". I want to have a text box on this form that shows the first value in a field that is in a different table called "DateWellPrevious". The field is called "Oil".

I tried this as my textbox control source, but it didn't work:

=[Tables]![DateWellPrevious]![Oil]

Any Suggestions?
-Chris

 

[ColinEssex]

Firstly, your form should be based on a query not a table.

If your relationships are right, you can call the other field via a subform linked via the master/child PK ID fields.

Col

 

[dopedealer]

As Col as explained, however, if you don't want to use a sub form , make a query and use D Lookup for the "oil" field.
Chris