Re: [AccessDevelopers] Get the value of field other than the bound column

[Toby Bierly]

Dim i For i = 0 To ListBoxName.Listcount - 1     If ListBoxName.Selected(i) Then         MsgBox ListBoxName.Column(1, i)     End If Next i   HTH, Toby ----- Original Message ----- From: john sayre To: AccessDevelopers@yahoogroups.com Sent: Monday, September 26, 2005 9:18 AM Subject: Re: [AccessDevelopers] Get the value of field other than the bound column This almost solves it...but this is a multi selected box and is only returning the last row.  How do I get a list of all of the selected rows for the non-bound column?   Thanks JPS Toby Bierly <[EMAIL PROTECTED]> wrote: Use the Column(number) property of the list box.  The column numbering starts with 0.  So for instance, to get the value in the second column of the selected row, use ListBoxName.Column(1) HTH, Toby ----- Original Message ----- From: "bitschon" <[EMAIL PROTECTED]> To: <AccessDevelopers@yahoogroups.com> Sent: Friday, September 23, 2005 4:22 PM Subject: [AccessDevelopers] Get the value of field other than the bound column > I want to get the value of a field in a list box that is not the bound > column.  Is this possible? > > How is it done? > > > > > > > > Please zip all files prior to uploading to Files section. > Yahoo! Groups Links > > > > > > > Please zip all files prior to uploading to Files section. Please zip all files prior to uploading to Files section. SPONSORED LINKS Microsoft access developer Microsoft access help Microsoft access database Microsoft access training Microsoft access training course Microsoft access programming YAHOO! GROUPS LINKS  Visit your group "AccessDevelopers" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.