help with list boxes and txt boxes

[Jediphase]

hi, i have a huge prob, wat needs doin some how im not fussy in how it works as long as it does the job.... i have a txt box called whotonotify, that is invisible for front end users, to make it user friendly i want tick boxes for the users - so there can b multiple selection, etc, how would i go about doing this? on the tick of a user e.g. "peter" it automaticaly places that name in whotonotify txt box. any help or sugetions on other ways wud be appreciated thanx

 

[Jack Cowley]

It is hard to follow what you want to do, but are you saying that you want more than one name in your "whotonotifiy" text field? If so then you want to reconsider your approach as you should not put multiple data in a single field.

If that is not what you want then use an Option Group for the names and a Select Case statment to send the name selected in the Option Group to the text box....

hth,
Jack

 

[Jediphase]

help with coding

thanx for your help...... i have thought of anothe method but im not v gud at makin my own code at all, wat i have done is.... kept my who to notify txt box, and created a combo box with all th users, cos multiple selection is a pain to display in a txt field i would like some help with makin some code for an add button i have created- wat this button needs to do is..... on click add the name thats in the user nema combo box, it needs to be able to have more than one user added, so the code needs to automaticaly but a semy colon or something, plz help

 

[Mile-O]

Change from a combobox to a listbox with Multi-Select set to Simple.

Put a button called cmdAdd.

Private Sub cmdAdd_Click()
   Dim intCounter As Integer
   Dim strNames As String
   For intCounter = 0 To Me.lstYourListbox.ListCount Step 1
      If Me.lstYourListbox.Selected(intCounter) = True Then
         strNames = strNames & Me.lstYourListbox & ";"
      End If
   Next intCounter
   txtYourTextbox = strNames
End Sub

 

[Jediphase]

i cant get it to add the selected name to my whotonotify txt box, do no y? thanx 4 the help

 

[Mile-O]

Maybe because you have more than column - have a look at this

 

[Jediphase]

YES!!!!!! it works............... thanx for the help i have been tryin all sorts for about 1 week now and u have sorted it just like that! wel thanx for ya help. if it want for my mate (jediphase) who let me use his membership here god knows how long it wud ave taken! LOL

 

[Mile-O]

No probs - it's easy when you know how!