Return Values on a Form

[booba0307]

I am creating a Database for work i have 2 tables linked together and
the Form that i am creating is based off a table that i created then
linked another table into the Database.

I need to lookup a field in a table and return the value to the from.

 

[fredg]

I am creating a Database for work i have 2 tables linked together and
the Form that i am creating is based off a table that i created then
linked another table into the Database.

I need to lookup a field in a table and return the value to the from.

To return data from a table use DLookUp in an unbound text control on
the form.

=DLookUp("[FieldName]","TableName")

You most likely will need to add a where clause to the above if there
is more than one record in that table.
See VBA help on DLookUp as well as
"Restrict data to a subset of records".