Text Box in Forms

  • Thread starter Thread starter abby
  • Start date Start date
A

abby

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
 
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 Brod


----- 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 200

Abb
 
Thanks for your help, Howard.

I think the combo box will work as you suggested. But I
need something further and have been unable to express
exactly what it is. I'll try again.

I need to give my users the ability to either choose
something on the list in my combo box or enter something
else which will be saved into the cmpName/cmpID field but
not added to the list they choose from. I want them to
get a question - "Do you want to add to the list?" when
they try to enter something that is not on the list.
Their answer will always be no but I want them to have the
ability to save the value for that field in that record.

I am having difficulty accomplishing my objective. I want
a list of a couple of items for the user to choose from.
But I also want the user to be able to enter something if
it is not on the list. So, say I give them an option
called "Other" as the cmpID, can I make THEM type in the
cmpName associated with that?

Am I making any sense?

Please help if you can.

Thanks.

-Abby
-----Original Message-----
Create a companies table (tblCompanies) with an ID field
Click to expand...
(cmpID), a name field (cmpName) and any other fields you
need.
Relate it to the other tables in your database using the
Click to expand...
cmpID field. also use the cmpID field for ComboBoxes and
data-entry forms.
Include tblCompanies and the cmpNames field in the source
Click to expand...
queries for your reports (so you can display the name
instead of the ID).
 
Back
Top