Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Displying ListBox Selection

Status
Not open for further replies.

Cohen227

MIS
Joined
Oct 30, 2001
Messages
8
Location
US
I am trying to display a selection from a ListBox which is on my form on a report that I am running. I have successfully accomplished this for text boxes but cant seem to get the ListBox selection to appear. I have used the following code:
Forms!MyForm.Form!MyListBox.Column(0)
This does not seem to be working. Any ideas???

Eventually, I would like to display multiple selections from the list box, which I know will require a loop. Im wondering where I'm supposed to type the code?

THANKS IN ADVANCE!!!
 
I usually add an invisible text box on my form. In the OnClick event of a command button to print the report, put something like this:
Code:
txtInvisField = Forms![MyForm]![MyListBox].Column(0)
You should then be able to reference txtInvisField in your report......
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top