[AccessD] Passing aarray index to docmd

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




More information about the AccessD mailing list