MartyConnelly
martyconnelly at shaw.ca
Tue Aug 22 14:25:00 CDT 2006
In the on click event of List0 List box ListIndex will give you the number regardless of sort order. Private Sub List0_Click() MsgBox " Index " & List0.ListIndex MsgBox " Count " & List0.ListCount End Sub Martin Reid wrote: > >I am trying to pass the index of an array to a Docmd. Cant get the syntax right. Any ideas? >I have a drop down list with a 0 based index. I need to grab the index and pass it to the docmd? > >Martin > > >Martin WP Reid >Training and Assessment Unit >Riddle Hall >Belfast > >tel: 02890 974477 > > > > >------------------------------------------------------------------------ > >No virus found in this incoming message. >Checked by AVG Free Edition. >Version: 7.1.405 / Virus Database: 268.11.5/425 - Release Date: 22/08/2006 > > -- Marty Connelly Victoria, B.C. Canada