Combo giving wrong results

[Guest]

I have combo box on a form with the following setting

the row source =

SELECT Vend_address_Q.VEND_SHRT_NM, Vend_address_Q.ADDR_LN1,
Vend_address_Q.CITY_NM, Vend_address_Q.ST_PRVCE, Vend_address_Q.CNTRY_NM_T,
Vend_address_Q.POSTAL_CD, Vend_address_Q.PH_NBR FROM Vend_address_Q;

Row source type = Table/Query

column count = 7
column widths = 2";2";1.5";0.5";0.5";0.75";1"
list rows =8
bound colum = 1

When I click the OK a report is ran which has the following code.
If IsNull(Forms![Project Key Info]![Combo44].Column(0)) Then
Me![Label63].Caption = "N/A"
Me![Label64].Caption = "N/A"
Me![Label65].Caption = "N/A"
Me![Label66].Caption = "N/A"
Me![Label67].Caption = "N/A"
Me![Label68].Caption = "N/A"
Me![Label71].Caption = "N/A"

Else
Me![Label63].Caption = Forms![Project Key Info]![Combo44].Column(0)
Me![Label64].Caption = Forms![Project Key Info]![Combo44].Column(1)
Me![Label65].Caption = Forms![Project Key Info]![Combo44].Column(2)
Me![Label66].Caption = Forms![Project Key Info]![Combo44].Column(3)
Me![Label67].Caption = Forms![Project Key Info]![Combo44].Column(4)
Me![Label68].Caption = Forms![Project Key Info]![Combo44].Column(5)
Me![Label71].Caption = Forms![Project Key Info]![Combo44].Column(6)

End If

Ok, once I select an item from the list and click OK the report runs but the
item I selected is not displayed the first items is always displayed.

I have another combo box setup the same way which works fine. the only
differance is the number of colums and that this combo box source is an
access table and the one above is a linked table(Oracle).

Dose anyone have any ideas why this combo box is not working? Thanks

 

[Guest]

After all this typing all I had to do was change the bound column to Zero and
set limit to list to Yes. Thanks