Hi,
Firstly, thank you for your help on this.
The following code should call a concat function whenever there is an Update to one of three List Boxes
and the text box should show the concatenated value, but nothing seems to occur...
Code:Private Sub List14_AfterUpdate() Call concat End Sub Private Sub List16_AfterUpdate() Call concat End Sub Private Sub List18_AfterUpdate() Call concat End Sub Private Sub concat() Me.Text20 = Me.List14 & Me.List16 & Me.List18 End Sub