Click to See Complete Forum and Search --> : Combo Box in Acess97


Shella
November 6th, 1999, 11:29 PM
Hi
I'm not familiar with VBA, could u pls tell me
whether COmbo Box in ACCESS 97 has the property of SelectedItem ? Coz I can't trace the item selected by the user after clicking the Combo Box.

Aaron Young
November 7th, 1999, 12:21 AM
It doesn't have the Selected Property, but, the Item Selected will held in the Text Property and the Index Number of the Item can be taken from the ListIndex Property for accessing ItemData, eg.

private Sub Combo0_Click()
Text1 = "List Index " & Combo1.ListIndex & " - " & Combo1
End Sub





Aaron Young
Analyst Programmer
adyoung@win.bright.net
aarony@redwingsoftware.com

Shella
November 7th, 1999, 09:23 AM
Hi
Thanx for ur answer, I just came across a method,
[Combo].itemdata(listindex) can serve that purpose. Anyway, thanks