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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AndyEduardo - 06 Dec 2005 12:18 GMT

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)

--
AndyEduard

Reply to this Message

Jeff Boyce - 06 Dec 2005 13:52 GMT

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, ...)

Signature

Regards

Jeff Boyce
<Office/Access MVP>

> Thanks for your attention
>
[quoted text clipped - 9 lines]
> My question is this, can I do that in the txt of the report without to
> make reference to other thing different of the form (table or query)?

Reply to this Message