Displaying data using the Calendar ActiveX Control

  • Thread starter Thread starter Liz Hansen
  • Start date Start date
L

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
 
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
 
It works.

Thank you very much.

Best,

Liz


Rick said:
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
Click to expand...
 
Back
Top