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