Filtering nested subform's records in A2K application

[Guest]

hello:

i have a nested subform (in ds view) called 'DaysView' sitting in my main
form called 'Screening Log (Edit Only)'. the linking via Parent/Child fields
is a little convoluted and may or may not bear upon the solution we can
conjure up (and ftb i'll defer going into them); suffice it to say that
there's a field on 'DaysView' called 'Date of Visit' (this is its subform
name, its name on the underlying table is 'DateOfVisit'). all this having
been said, what i'm aiming for when the user is looking at the form/subform
is for the user to be shown only those records on the subform that come on or
after the 'Date' that the user is using the application (which btw is an
A2K-er). so, i have tried a couple of permutations of this and that idea, but
not with a lot of 'luck'. i'm debating w/ myself whether we should allow any
user input over the filtering action once the technique's sussed out or
whether there ought not to be (i.e. the user has no choice but to see only
those subform records that have 'Date of Visit' entries falling on or later
than the same 'Date' that they're being viewed.

any ideas'd be greatly app'd!

-ted

 

[Allen Browne]

Answered in another group where you posted this q.