List box Click Event

[garyd1234]

Hi,
I have a form with several list boxes on it. Down the side of the list box are dates. My intent is to have a person click across from the date they wish and there is code on the on click event of the list box that takes them to a form. Well (Access 2000) sometimes when they click in the list box the line where they click just turns black and won't do the onclick code. They have to click somewhere else on the list box to get the form, close it, then click the date they want. Sometimes after 2 or 3 clicks it gives the MS.ACCESS has generated errors and will shut down message. What's up with that? Thanks

 

[PerkinsSlave]

Not sure if you've worked through this yet, but I may have set up something similar. I made my list box a combo box instead, then defined the values (in your case dates) I wanted my users to select from. I then created an OnChange event in Access to procede off the selection. This should work unless the dates in your combo box are constantly changing...

Where "cmbCombo" is your combo box, and "Date1" and "Date2" are your como box's rowsource:


Private Sub cmbCombnChange()

If me.cmbCombo.Value = "Date1" Then
Call WhateverYouWant
ElseIf me.cmbCombo.Value = "Date"2 Then
Call WhateverYouWant2
End If

End Sub

 

[bat17]

Sounds like you may have a corrupt db, try running the repair utility

Peter