Hello SP,

The ListIndex property is updated when the user selects an item in the
ComboBox List. ListIndex is a subproperty of the List property. You
code should read...


Code:
--------------------
Private Sub txt_Facility_Name_Click()
' Get index number of selected record
With txt_Facility_Name
facilities_current = .List(.ListIndex) + 1
End With
populate_facilities
End Sub

--------------------


Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=479989