R
Rick in NS
I would like to place a 'Find' command button on a main form to present a
custom find dialog to enter search criteria for ALL records produced in the
underlying query of the subform (not just those presently filtered). The
subform is filtered by WeekID bound to the main form by WeekId.
Although the command button has to reside on the main form due to the fact
the subform is in datasheet view; the search must include all records
matching the criteria, i.e. assuming the text box on the custom Find dialog
is strSearchText :
Like "*" & strSearchText & "*"
Once the user has located the desired record it has to be bookmarked and the
view moved to the week that the record appears in.
I have looked at Allan Browne's tip on filtered records in subforms but it
does not appear to address this situation.
Any help will be appreciated.
custom find dialog to enter search criteria for ALL records produced in the
underlying query of the subform (not just those presently filtered). The
subform is filtered by WeekID bound to the main form by WeekId.
Although the command button has to reside on the main form due to the fact
the subform is in datasheet view; the search must include all records
matching the criteria, i.e. assuming the text box on the custom Find dialog
is strSearchText :
Like "*" & strSearchText & "*"
Once the user has located the desired record it has to be bookmarked and the
view moved to the week that the record appears in.
I have looked at Allan Browne's tip on filtered records in subforms but it
does not appear to address this situation.
Any help will be appreciated.