William Benson (VBACreations.Com)
vbacreations at gmail.com
Thu Aug 11 12:12:15 CDT 2011
I click on n item in a listbox and I can tell I have selected it but
whenever I test for Selected = true, Access is not reporting the true state
of the selected property.
There are column heads.
Any idea why?
Function ActiveReportID() As Long
Dim i As Long
Dim Frm As Form
On Error Resume Next
Set Frm = Forms("FrmMatchReport")
If Frm Is Nothing Then
ActiveReportID = 0
Exit Function
End If
With Frm
For i = 1 To .Controls("cboReportHeader").ListCount - 1
If .Controls("cboReportHeader").Selected(i) Then 'Seems always to be
false even when staring at the control I can tell it's true!
ActiveReportID = .Controls("cboReportHeader").Column(0, i)
Exit Function
End If
Next
End With
End Function