Edit calender code further

[Guest]

Private Sub Calendar5_Click()
findappoint.Value = Calendar5.Value
findappoint.SetFocus
Calendar5.Visible = True

What could I add to this code in order to refresh the form after the date is
selected. I have a filter for the date placed in an unbound box from the
calender, but you have to use a button to refresh the page every time a new
date is pressed. I would like to alleviate this extra step.

 

[Greg G.]

Aaveer said:

Private Sub Calendar5_Click()
findappoint.Value = Calendar5.Value
findappoint.SetFocus
Calendar5.Visible = True

What could I add to this code in order to refresh the form after the date is
selected. I have a filter for the date placed in an unbound box from the
calender, but you have to use a button to refresh the page every time a new
date is pressed. I would like to alleviate this extra step.

Behind the form in question,

me.requery

Place at the end of the even code that updates the filter.

FWIW,

Greg G.