String concatenation and Combo boxes!

[purchaandr]

Hey there guys,

I was wondering if anyone could help me out. I'm currently working on a project and i need to concatenate 3 fields to make up the value in another text box. the three fields consist of 2 text boxes and one combo box.

I am using the afterupdate event to put the strings together and I can get the text boxes joined together, but the value i am getting from the combo box is the ID, not the text value stored in the combo box.

The code I am using in VB in the afterupdate event is as follows:

[Opportunity Description] = [Company] & " " & [Type] & " " & [Project ID]

[Project ID] is the combo box value and is returning the ID (e.g 1) instead of the project name which is shown in the combo box.

Any help would be much appreciated!

thanks,

Andrew

 

[scalextric59]

[Opportunity Description] = [Company] & " " & [Type] & " " & [Project ID].[Column](1)

the index is zero based. If the description is in the second column then index is 1

 

[purchaandr]

hey there scalextric,

I had found that stuff before but had been putting 0 as the parameter! That last line you wrote explaining sorted me out quite nicely as i needed to put 1 in to reference the second column!

Thanks heaps!