Select text to be added to another text field

[Valery]

Hi all!

I have a Unit Inspection form where I would like to facilitate the data entry (many many fields).

I would like to have a list - dropdown or individual text boxes at the top of the subform, that would provide the followng choices:

To be repaired; To be replaced; To be cleaned; To be removed; To be repainted... and so on.

I would like the user to be able to select more than one to be copied to his text box. For example:

Window/trim : To be repaired; To be repainted.

How can I accomplish this? Please note I am only at a beginner/intermediate level as far as VBA is concerned. Please provide full, comprehensive coding.

THANK YOU!

 

[Grumm]

Since you are 'beginner/intermediate' I guess you tried something already ?
If that is the case maybe you can show us the code and we can help you fix that.

are the choices in a list or just buttons ?

 

[Valery]

I simply created a combo box with value list. Used the mouse to select, then copy, then paste.

Would like to automate this or something better. That is all I tried. I don't know how to code it which is why I posted it.

I would like a mechanism, button or other, that would do the copy and paste text without replacing whatever text is in already in the text box.

 

[Minty]

I would think the best route would be to create a multi select list box with the actions available, and a button to take the selected items and either
a) Concatenate them together in a single field
b) Add them to a list of things to be done that can be individually signed off/completed?

I would have thought b) would be more useful long term.

 

[Valery]

Thank you Minty.

Each items, in each area (kitchen, living room, dining room, laundry room...), i.e. Kitchen - door, Kitchen - wall, Kitchen - sink, kitchen counter and the list goes on - must have a field that allows the user to type in whatever he wants as an explanation.

Your a) suggestion is better than b), in this case. I cannot create another 200 fields so that each item in each area as a choice of "to be...".

Would you know how can implement your a) suggestion that would concatenate multiple choices, copy them, and paste them into the user explanation text field? I don't know how to code that into VBA or other.

I do not want to list them already concatenated... that would be too much to read... I only included a sample here of the choices.

Thank you - looking forward to getting codings I can implement and try out.

 

[jdraw]

Step back and give readers a 5-6 line overview of WHAT your business problem/opportunity is in simple plain English. You don't start with a form. You start with a problem or opportunity for which you( or your boss) thinks some type of automation will "solve". So, if you tell us in plain English WHAT the problem/opportunity is, you will get more focused responses and even options for HOW it might be addressed.

Good luck.

 

[Minty]

You shouldn't need 200 fields, just a table with 3 or 4 fields - Unit ID, Area(ID), Action(ID), and Completion date, possibly who the task was assigned to?

This will make managing what has happened or needs to happen much easier. Think Vertically with the fields not horizontally.

 

[missinglinq]

If I understand your requirement...replacing YourComboBox with the name of your Combobox and TargetTextBox with the Textbox to hold the data:

Private Sub YourComboBox_AfterUpdate()
 If Nz(Me.TargetTextBox, "") = "" Then
   Me.TargetTextBox = Me.YourComboBox
 Else
   Me.TargetTextBox = Me.TargetTextBox & ", " & Me.YourComboBox
 End If
End Sub

Linq ;0)>

 

[Valery]

Thank you all, thank you missinglinq - I was able to apply your solution!

 

[missinglinq]

Glad we could help!

Linq ;0)>