Concatenate Values Not Index

[bw]

I am using a field [SeatsContact] on my report that in design mode, looks
like a drop down box. The Row source for this field follows: SELECT
[zPTContracts].[ContractsKey], [zPTContracts].[Contracts] FROM
[zPTContracts]

If I concatenate like this: ="Seats " & [SeatsContact]...........I get a
value as follows (for example): Seats 11
I want to be able to concatenate as above, but with the text value of
[SeatsContact], not the index.
How is this done?

Thanks,
Bernie

 

[Duane Hookom]

Set the Row Source to:
SELECT [ContractsKey], "Seats " & [Contracts] FROM [zPTContracts]
Set the column widths to:
0",2"
Bound Column:
1
This assumes your control source is related to the ContractsKey field.