Is it possible to use fields from a table as static text in a form?

[thekruser]

What I have:

tblSetup
-Company name
-Address
-Phone number
-etc, etc

What I am trying to do:

The database I am working on will eventually be distributed to certain parts of my organization. I would like the gaining admin to be able to simply enter the requisite information in the set up table and have that information replicated throughout the forms and reports.

The problem:

I think I can figure out the reports part (but any pointers would be helpful); however, I simply cannot get it to work in forms. The problem comes when Access tries to relate tblSetup with the tables being used in the form. Is there a way to simply add data from tblSetup as static content on a form?

Thank you in advance for your time and help.

[pbaldy]

I suspect trying to include the table in a query without a join will result in a read-only query. You could use a textbox with a control source of:

=DLookup("CompanyName", "tblSetup")

To avoid repeated calls to the table you could load a hidden form with the values on startup and simply refer to that form from other forms and reports. You could also use a little subform bound to that table and include it on other forms.