Unbound Field in Form

[Tommy]

I have an unbound control on a form that I want to
populate with information from another table that is not
the recordset of the form. Is this possible? If so how?

 

[Marshall Barton]

I have an unbound control on a form that I want to
populate with information from another table that is not
the recordset of the form. Is this possible? If so how?

Several ways to do that. Maybe a simple DLookup is all you
need. In some cases where the two tables are related, it's
better to Join the two tables in the record source query.