Unanswered: Update ControlSource with OnClick event doesn't work, but works with KeyPress?
I created a listbox that gets its information from a query that contains name, phone number, etc... and I've hidden the columns that I don't want to see. I created an event procedure that fills unbound text boxes with the hidden info when I click on a name. At the same time, I want to update the control source of two checkboxes to reflect the currently selected name. This is what I tried:
Private Sub IntrpList_Click()
row_int = Me.IntrpList.ListCount
For row_int = 0 To Me.IntrpList.ListCount - 1
Originally posted by axsprog
requery the listbox after the click or repaint the form Not enough here to go by , it is strange that the key event works using the exact code.
Thanks for posting. The problem actually just went away at some point - I have no idea why. I could probably replicate it and try to debug it, but I'm glad just to be done with it and move on. If anyone else has this problem, post it here and maybe we can work it out together.