ActiveX Calender Control not requerying Subform (1 Viewer)

tinyevil777

Registered User.
Local time
Today, 07:58
Joined
Dec 10, 2010
Messages
137
Hello all,

I have a table called 'Tasks', where a date is entered along with a short description of the task.

I then created a form with an ActiveX 'Calender' on. I also created a subform, this is a datasheet view of all records in the 'Tasks' table.

When i click on a new date on the Calender, the subform should be requerying, thus showing all records relevant to the date. However, it doesn't work. It only shows the correct data once i press F5 to refresh.

I have set the following code in the Calenders' 'On Updated' event.

Code:
Private Sub Calendar0_Updated(Code As Integer)
    Me!TasksSubform.Requery
End Sub

Is there something glaringly obvious that i've missed off?

Have attached the database for anyones perusal, thank you in advance for anyones assistance on this one.
 

Attachments

  • Calender-Jobs link.mdb
    312 KB · Views: 85

tinyevil777

Registered User.
Local time
Today, 07:58
Joined
Dec 10, 2010
Messages
137
Thanks for your reply Spike, yes, that previous post answered my question perfectly.

I do always use the 'Search' option for related posts before posting a query; my terms must've been well off.

Either way, thanks for your help!
 

Users who are viewing this thread

Top Bottom