Hi, I have 3 listboxes on my form and Form Load code is
The listboxes show the expected values and change with their arrows.
But if I try and read that value in code, they are Null.
Debug Print List4 = Null
Debug Print List4.Value = Null
What am I doing wrong ?
Thanks.
Code:
Private Sub Form_Load()
Dim i As Integer
For i = 1 To 100
listPosFrom.AddItem i
listPosTo.AddItem i
Next
List4.RowSource = "SELECT DISTINCT tblMain.Year FROM tblMain WHERE (((tblMain.Year)>='" & Me.OpenArgs & "'));"
End Sub
The listboxes show the expected values and change with their arrows.
But if I try and read that value in code, they are Null.
Debug Print List4 = Null
Debug Print List4.Value = Null
What am I doing wrong ?
Thanks.