Access Calendar Control on an unbound form.

[jazzz]

Hello all and thanks in advance for any help.

I have an unbound form that contains the calendar control where I would like to be able show the user which employee's are scheduled to work in a specific department on the day selected in the calendar control.

There are five subforms on the main form for each department. Each Subform has a date field that contains the date the employee is scheduled to work. What I would like to accomplish (if possible) is when you select the date in the calendar filter all the subforms by that date. But for the life of me I can't seem to get it or can I find anything on doing something like this.

Is it possible? And what event would the filter fire on the calendar control? Again thanks for any help.



Life's a journey enjoy the ride...

jazzz

 

[ZmrAbdulla]

1. Create a master table contains only a masterdate field
2. Set master form's recordsource to this table.
3. Link all the sub forms with the master date field.
4. Then you can have code like this

Private Sub CalendarControl_Click()
    Me.MasterDate.Value = Me.CalendarControl.Value    
End Sub

________________________________________________________
Zameer Abdulla
Help to find Missing people

 

[TheAceMan1]

How are ya jazzz . . .

All you need to do is [blue]filter[/blue] the subforms on the date selected . . .

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[jazzz]

Thank you guys but here is what I did and it worked. I created an unbound text field on my main form. In the current event of my main form I set the value of that text field to my ActiveX Calendar control value. On my calendar control I added to the afterupdate event the value of my Calendar control to my unbound text box. Now I set the links for master and child in my subforms to the hidden date field on my main form to the date field on my subforms and presto it all came together. Now whenever you select a date on the calendar all the subforms now sync and show the personal scheduled to work on that date.

I just completed this late last night and planned on posting the fix this AM as I am doing now. Thanks everyone for the help.

Life's a journey enjoy the ride...

jazzz