Requery subform

[Guest]

I have two subforms on a form. The main form has a text box displaying a
selected date (date selected from a Calendar control). Also on the main form
a cbo box allows a user to then select a person and that persons appointments
for that particualr day appear on tsubform 1. Subform 2 is to display all
the appointments for that day (not just the person selected in the cbo box).
I can't get subform 2 to requery. I don't want it to just requery after the
cbo box value changes because I want all the days appointments to show on
subform 2 after a new date is selected - the user may not select a person
from the cbo box they may just look at subform 2 after selecting a new date.

Any clues?

I have tried requery on a number of events of both the main form and it's
controls.

nB

 

[Guest]

Thanks for all the help team but I have solved this one myself.

The Calendar form calls a public function Calendar() and passes the
arguement (selected date) to it. I put the requery statement into the code
in the Calendar() function so every time this runs (after new date selected
on Calendar control) subform2 requeries and shows fresh info. Works like a
dream.

Cheers,

nB