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.

"acs68" <(E-Mail Removed)> wrote in message
news:#uNQvZE#(E-Mail Removed)...
> 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
>
>