Concatenate Values Not Index

  • Thread starter Thread starter bw
  • Start date Start date
B

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
 
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.
 
Back
Top