Solved

Populate text box by selecting from pre-defined list

Posted on 2011-03-21
2
353 Views
Last Modified: 2012-05-11
I have a db that is used to track repair details of electronic assy's

The repair detail form has a field to enter repair detail that will be given to our customer.  

I would like to create a predefined list for the technician to select one or more items from and have it auto populate these items into the customer repair detail text box.

The list would contain items such as:  Electrically failed component; Wrong component installed; Unit passes test; NPF, etc...    

Thank you for any help you can give.  
0
Comment
Question by:bjmarcley
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 44

Accepted Solution

by:
GRayL earned 500 total points
ID: 35183238
Create a listbox in which you have the multiple select property set to Simple or Extended.  Populate the listbox using either a table or a list of values, and create the string using the ItemsSelected property of the list box.  If you go to the VBA window (Alt+F11), in Help type = ItemsSelected for details on how to use the feature.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question