Calendar Control will not close on subform

[kentwood]

I have attached a condensed copy of my form/sub-form that has calendar controls on it for the RecvdDt and the Compliance date. I have it set up the say way as I have on other databases and it will not close/populate once opened. I have reset the events on it multiple times and I just can't get it to go.

Can anyone please take a quick look and help me determine why it is not working on this form yet works on others that I have.

Thanks.

 

[RuralGuy]

You might want to include some dummy data so the forms can be run.

 

[kentwood]

I apologize but when I pulled the files into my zip file I pulled from the linked files rather than the data files. Hope this new attachment will help.

 

[RuralGuy]

A big issue will be that the query that the ComplianceFinalSubform is bound to is not updateable. You will have to fix that first and that may get the calendar working properly again.

 

[kentwood]

Actually, I was working on that very problem of the form update situation when I read your response. Had to adjust my queries and change the data input from Yes to No. It is OK now although when I zip it up it becomes read only. In any case, the calendar control still does not work

If I can have help with that, I am all set. Thanks.

 

[RuralGuy]

For some reason the frmCalendar OnClose code got detached from the event. Go to the event tab and click the '...' button next to OnClose and it will re-attach.