Store the value in a table, and use DLookup in the text box to display the
name on the report.
For example, if you have a table named tblSys, with fields:
TheVariable (text, indicating what is stored, primary key)
TheValue (text)
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13019Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13019
you could create a record like this:
CompanyName XYZ Ltd
Then the text box on the report would have this Control Source:
=DLookup("TheValue", "tblSys", "TheVariable = 'CompanyName'")
For more help on DLookup(), see:
Getting a value from a table: DLookup()
at:
http://allenbrowne.com/casu-07.html
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Simon"
wrote in message
news:0FE9CD16-EAA0-444C-8305-6A378A1CDE6C@microsoft.com...
> What is the best way to have my company details print in all reports. I
> assume there is a better way than manually adding labels to each report,
> however, if I enter the details in a New Table called say 'Company
> details'
> how does that then relate to the other tables. I am using Access 2003 and
> XP.
> Thanks for any help.
Our Donation Goal
: Why Donate? : Donate Today! : Donate Anonymously (ਗੁਪਤ) : Our Family of Supporters 
Linear Mode
