T
Ted
hi all,
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 is for the user to be shown only those records
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
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 is for the user to be shown only those records
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