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

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
 
N

noodnutt

G'day

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

me.MySubForm.Requery

HTH.

Mark.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

refresh/requery subform 2
Refresh Data in a subform 2
Subforms won't refresh after new record 0
Subforms won't refresh after new record 3
Basing a subform on a selection from either of two subforms 3
Calculated control not displaying zero when recordset is empty on 5
On Click, Open a form, choose a selection then have it populate fi 8
Acc 2007 Subform Recordset vs Acc 2002 Subform Recordset 2

Top