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 gkittelson 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
Oct 30, 2001
8
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