Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 356
  • Last Modified:

Populate text box by selecting from pre-defined list

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
bjmarcley
Asked:
bjmarcley
1 Solution
 
GRayLCommented:
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now