All,
I posted this earlier yesterday and thanks to David, for his
codes here. It kinds of work, but not always.
I have a MainForm with a subform. When I place the following
code in the Subform's On_Open, it only works for 1x (at open) when the
mainform is open with the subform. When I goto another record in the
main form, it quits working (i.e. not the most recent dated record is
on the top, however, I can browse the records within the subforms; it
says "You can't goto specified record")
==============================*=================== =====
With Me.RecordsetClone
.FindFirst "[Date1]<=#" & Now() & "# AND [Date2]>#" & Now() & "#"
If .NoMatch Then
MsgBox "No records matched your criteria."
Else
If Me.Dirty Then Me.Dirty = False
Me.Bookmark = .Bookmark
End If
End With
==============================*=================== ======
If I place the above codes in On_Current event, it works when I
go from records to records to display the current calender schedule in
the mainform, but I can not goto anther record within the subform!
What else event can I use? (I have tried them all, pretty much)
Or can the above code be modified to fit my situation? Please help.
P.S.: the mainform and the subform are linked by a Record#
Sincerely,
Perry