RE: Text Box in Forms

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Howard Brody (anonymous_at_discussions.microsoft.com)
Date: 05/10/04 

Date: Mon, 10 May 2004 08:31:03 -0700

Create a companies table (tblCompanies) with an ID field (cmpID), a name field (cmpName) and any other fields you need.

Relate it to the other tables in your database using the cmpID field. also use the cmpID field for ComboBoxes and data-entry forms.

Include tblCompanies and the cmpNames field in the source queries for your reports (so you can display the name instead of the ID).

Hope this helps!

Howard Brody

     
     ----- abby wrote: -----
     
     I want my users to type in RRP in a textbox (which is an
     abbreviation for a company name and address). When this
     textbox is printed on a report, however, I want the entire
     company name and address to appear. How can I accomplish
     this? This entry will be the most common but I don't want
     it to be a default entry.
     
     Access XP/Access 2002
     
     Abby