Strange things (1 Viewer)

[Treason]

i have some code on click of a list box

Private Sub ReqCourses_Click()
MsgBox Me.ReqCourses.Column(0)
End Sub

Everytime I click an item on this list box nothing happens... no error no msgbox. It's referenced properly.. name of listbox matches name in code window.

I also have a command button to grab the value from the listbox but thats not working either.

Private Sub Add_Click()
MsgBox Me.ReqCourses.Column(0)
End Sub

When I click the command button i get an Invalid use of Null error.. which is wierd because I clicked an item in the listbox first.

I dont know what is going on... am I overlooking something?

 

[M8KWR]

Is your list box actually called "ReqCourses" is my first thought.

How many columns to you have in it, and what field do you have bound.

For the msgbox not to work it has not gone through the procedure, try breaking the procedure so you can step through it, and see where it is going and why it is not working like it should, and then you should find the issue.