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.
Printable View
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.
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
[email protected]
[email protected]
Hi
Thanx for ur answer, I just came across a method,
[Combo].itemdata(listindex) can serve that purpose. Anyway, thanks