Select Information from cbo in a form a show second column in report

[AndyEduardo]

Thanks for your attention

I have one form, and I want to make a report about this, there is a cb
in the form that show CostumerID(first Column), CostumeName(2nd Column)
I want to see in one txt of the report the Constumer's Name , not th
CostumerID........I want to say that...in the txt of the report I wrot
..... =Forms!Invoice!cboCostumerID it shows CostumerID of course, but i
the form the cbo don't shows CostumerID because I wrote in ColumnWidt
0cm;2cm, and evidently I can't to see the CostumerID and I can see th
Costumer's Name

My question is this, can I do that in the txt of the report without t
make reference to other thing different of the form (table or query)

 

[Jeff Boyce]

Andy

In your report, you could refer back to the value of that second column in
the form's combo box, using something like:

=Forms!Invoice!cboCostumerID.Column(1)

(you use Column(1) because .Column() is zero-based -- first column is 0,
second is 1, ...)