Display Combo box result in Report

C

cpurpleturtle

I have form with a combo box that is populated by a table. The table has
person's name and telephone number. I need to display the telephone number
on a report depending on who's name was chosen in the combo box.
Thanks for your help!
 
T

Tom van Stiphout

On Thu, 15 May 2008 18:15:00 -0700, cpurpleturtle

Put a textbox on the report, and set the ControlSource to:
=Forms!MyForm!MyCombobox.Column(1)

Of course you need to replace MyForm and MyCombobox with the object
names in question.

-Tom.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report, Combo-Box 1
Combo Box data 8
Update Records in Current Table and another Table 5
combo box filter 1
Using data stored in a combo box 2
Newbie Help with form 1
Showing combo box box that's not an option in its drop-down list 5
Combo Box Values 5

Top