How to update a text box from a 2nd table

  • Thread starter Thread starter keers
  • Start date Start date
K

keers

Hi All,

I have a table (tblCompanyDetails) with 1 record. The record contains
fields such as; CompanyName, Address1, Address2, Address3, City,
Postcode, Phone, Fax.

I now have numerous reports based on other tables and queries, which i
want to add a footer to. I have placed a text box in the footer, thatI
want to populate with the items from the tblCompanyDetails. This
doesn't appear to be as straightforward as i had hoped, as I cannot
seem to get the textbox to take the data.

Any guidence would be appreciated.

Thanks

Kiers
 
Make the control source of the textbox
=DLookUp("CompanyName","tblCompanyDetails")
or change CompanyName to any of the other fields in the table.
 
Back
Top