Calendar Control

S

stevew

Access 2003 Windows XP

I have an ActiveX Calendar on a sub form. I have placed the following code
to add the calendar date to a text box which then requeries a List Box. This
works OK.

Private Sub Calendar_DblClick()
txtDate.Value = Calendar.Value
LstAppointment.Requery
End Sub

I want to requery the the list box when I click on a date once e.g.

Private Sub Calendar_Click()
LstAppointment.Requery
End Sub

This doesn't seem to work and I'm a bit lost here. I would assume that if
the List Box will requery on a double clik then it should with a single
click command. I know I'm missing something any help would be appreciated.

Steve Walker
 
Top