Calendar change needs to requery subform

[Guest]

Hi groupies.

I have a subform tied to a query. The date of the query uses the date on the
calendar of my main form as criteria.......my thought being that when the
date on the calendar changes then the date of the query changes as well.

I added a requery statement to the On Updated event of the calendar, but the
subform will not change until I hit enter and then it also moves to the first
record in the sub, I would like it to stay on the current record.

My code for the calendar event is simply:

Private Sub CalCtl1_Updated(Code As Integer)
Me!fsubDailyBoxes.Requery
End Sub

Any ideas??

 

[Guest]

the subform is going to the first record because there is no criteria telling
it to do otherwise....

whatever criteria told the sub to be at record X needs to be held somewhere
and available as criteria for when the sub or query reopens..