Displaying data using the Calendar ActiveX Control

[Liz Hansen]

Hello,

I'm hoping to do something to this effect:

I have a form on which I have added the Calendar ActiveX control. I have
also added a sub form (sfrm1) which Record Source is a table containing
names and dates.

I would like to filter the subform by selecting a date on the calendar. For
example, if I click on August 25, 2004 the subform should be automatically
updated and only show names associated with the same date.

Any suggestions on how to do this is very much welcome.

Thanks!

Liz

 

[Rick]

Hi Liz,

I have a form with a Calendar Control on it and display the data for the
date I select in a subform (CalendarVanSchedule).
How I did it was to place a Command Button on the Main Form. In the "on
click" event put some code like the following;

Private Sub cmdOrders_Click()
CalendarVanSchedule.Form.RecordSource = _
"Select * from CalendarVanQuery Where fldDate = #" _
& calPickADay.Value & "#"
End Sub

Hope this helps.
Rick Thorpe
Digitech Data

 

[Liz Hansen]

It works.

Thank you very much.

Best,

Liz

Hi Liz,

I have a form with a Calendar Control on it and display the data for the
date I select in a subform (CalendarVanSchedule).
How I did it was to place a Command Button on the Main Form. In the "on
click" event put some code like the following;

Private Sub cmdOrders_Click()
CalendarVanSchedule.Form.RecordSource = _
"Select * from CalendarVanQuery Where fldDate = #" _
& calPickADay.Value & "#"
End Sub

Hope this helps.
Rick Thorpe
Digitech Data