How to update a text box from a 2nd table

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
 
D

Dennis

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Labels with blank text box 1
Errors with text box formulas 4
Populating textbox with more than one row of text 1
How to make a address label ? 1
How to add a return in a text box if second field has data 7
Help with code to hide/unhide text box and label? 3
Formatting Text from a query 2
insert into table 1

Top