Line count from the dropdown box in Form

[Cogivina2004]

I have a dropdown box in the form in access. It lists all the state names. If I select CT, my State = CT and my StateNum = 2. How do I write code to get the index of the state that I selected? Thanks

1 AL
2 CT
3 NY


Sub Enter_click

State = MyForm.State
StateNum = MyForm.State.linecount???
...

unload me
end sub

 

[Rofeu]

I'd try the ListIndex Property

Hope it helps,

Roel

 

[Cogivina2004]

Thanks, I did not realize it is based 0.