Referencing a value list combo box column in Acces SQL Query

[camel66]

I have a combo box named strinter with the following values

1 Outside USA
2 Inside USA

I am bounding column 1 and have set column widths to 0";1"

On a form I want to have a lookup combo box that lists the travel destination strdest and strinter.

The problem is when i conctanate the 2 strinter value shows up as a number so i get something like this

Africa - 1

I want Africa - Outside USA

I want to store the number in my table, not the text.

so I tried to reference the column in an SQL, however i get an error that is is not a defined function. can someone help

here is the SQL statement


select lutravdest.alpha3, lutravdest.dest & " - " & lutravdest.strinter.column(1) as Dest
order by lutravdest.dest

Your help will be appreciated

 

[braindead2]

best bet to create a table with the 2 values and refer to the table
Or try something like
lutravdest.dest & " - " & IIF([strinter]=1,"in usa","Outside usa&quot
OR simply refering to the control as me.controlname.column(1) may work
good luck