Kaup, Chester
Chester_Kaup at kindermorgan.com
Mon May 21 12:51:42 CDT 2007
I didn't think that was a problem if multiselect was set to none. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of McGillivray, Don [IT] Sent: Monday, May 21, 2007 12:09 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] List Box Selection on a Report Chester, The problem is that a list box might have multiple selections made, depending on the multi-select mode that is specified for the control. So you can't just refer to the control, you have to tell it which item(s) in the list on the control you want. One way to do this is to loop thru the ItemsSelected for the list box: Dim varItem as Variant For Each varItem in Me!MyListBox.ItemsSelected '(. . . Your Code Here . . .) 'Use Me!MyListBox.ItemData(varItem) to retrieve the value in the bound column of the list box. 'Use Me!MyListBox.Column(ColumnIndex, varItem) to retrieve values from other columns Next Hope this helps. Don -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester Sent: Monday, May 21, 2007 8:09 AM To: Access Developers discussion and problem solving Subject: [AccessD] List Box Selection on a Report I have form with a list box on it. When the user clicks on a selection, an on click event runs that opens a report based on the selection. This works fine. Now I need to display the list box selection in a text box on the report. I set the text box control source to =Forms]![Form1]![ManifoldList]. This just returns Name? What might I be doing wrong? Chester Kaup Engineering Technician Kinder Morgan CO2 Company, LLP Office (432) 688-3797 FAX (432) 688-3799 No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com