Where am I going wrong?
I have a form which has a record for each date on which I teach. It
has a subform which shows the classes that I teach that day. So I want
to be able to click on a calendar and jump to the selected day, so that
I can make plans for each class etc.
My form has a field TeachDayDate which is Date/Time, which comes from
an underlying table/query.
I want to be able to click on a control, such as DTPicker3, or the
Calendar control so that I can view the record for the chosen date.
I have followed the help and done the module stuff and pressed F5 so
that the ActiveX control is recognised.
All I can do is have a txtDTpicker show the date picked - but only
after I manually refresh the records from the toolbar. How can I force
a refresh/whatever from code?
I have tried using a filter criteria in the underlying queries
TeachDayDate: [txtDTPicker3] but this doesn't work.
I have tried
Set rs = Me.Recordset.Clone
rs.Findfirst "[TeachDayDate] = '" & Me![DTPicker3] & "'"
Me.Bookmark = rs.Bookmark
and that doesn't work either.
How can I use DTPicker3 in either expressions or queries so that I can
move to the record for the selected day?