Calendar Control - Subform only refreshes when I click into it after choosing date on Control

  • Thread starter Thread starter acs68
  • Start date Start date
A

acs68

hi all,

I have an unbound form that has a Calendar control (Active X - Access 2000)
and a combo box that I use to populate the subform.

when I choose the combo box and click on a date (CalCtrl), the subform
should display only those records that apply to those two variables.

I have to actually use the mouse to click into the subform and all the
appropriate records display.

Is there something I need to do on the Calendar Control event to refresh the
subform - or something like that ?

tia,

Adam
 
G'day

Which ever is the last control you use to filter your subform, place a
requery.

me.MySubForm.Requery

HTH.

Mark.
 
Back
Top