Getting Data from linked table in a form 1

[OzzieOwl]

I am new to Access VBA and am struggling with some code.
I don;t know if this is possible or not, any help would be appreciated.

I am triggering the code on exit of a field in a form, and I need to pick up the value of a field in another table, which is linked in via referneces, to the table that the form is updating.

What I need to know is the syntax for picking up field value from another linked table. (If this is possible)

Thanks

Ozzie

 

[SimonDavis]

Have a look at Dlookup (domain aggregate functions)

If I'm reading you correctly, you want to get a record from another table where a piece of data on the current table matches one in the second table?

The syntax would be something like;

field2.value = dlookup(fieldwithonfoyouwant.value,othertable,fieldoncurrenttable=fieldonothertable)