Hi Nick,

Try inserting code in your calendar's click event procedure to force the
requery. For example, here is a procedure I use in an unbound Query by Form
(QBF) in conjunction with Allen Browne's calendar:
http://allenbrowne.com/ser-51.html

Private Sub cmdFromDateRaised_Click()
On Error GoTo ProcError

  Call CalendarFor([txtDateRaisedStart], "Starting Request Date")
  RequerySubform

ExitProc:
  Exit Sub
ProcError:
  MsgBox "Error " & Err.Number & ": " & Err.Description, _
         vbCritical, "Error in procedure cmdFromDateRaised_Click..."
  Resume ExitProc
End Sub

In my case, the RequerySubform procedure is a function that is called from
the After_Update event procedure of combo boxes, text boxes, list boxes, etc.
on my QBF form. As you can see, I also call it from the click event for the
command button that opens the calendar form.

Tom Wickerath, Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________